sorry, in Binary I always think in bits rather than bytes....
On 18 Sep, 09:41, sallushan <[EMAIL PROTECTED]> wrote:
> In SQL Server
>
> binary(8) = 8 bytes = 64 bits
>
> NOT 8 bits
>
> On Sep 17, 11:01 pm, CK <[EMAIL PROTECTED]> wrote:
>
>
>
> > an 8-bit binary can't be used to store a date - there isn't enough
> > information,. Who designed your database?
>
> > On 17 Sep, 02:35, Benj Nunez <[EMAIL PROTECTED]> wrote:
>
> > > Hello experts,
>
> > > I was given a task to retrieve (copy) a date entry (a varchar) in a
> > > DB2 database. Once I get it into my app, I will convert it to a date
> > > first to test it if it's a valid date (e.g. using
> > > DateTime.ParseExact).
>
> > > My problem is, I am required to save (paste) this to a SQL Server
> > > table. There's a field called
> > > "PROCESSED_DATE" in there with a data type of "binary(8)". I was
> > > expecting that the
> > > data type would be "Date/Time". But that isn't the case.
>
> > > My question is, how do I save a literal date to a field that is a
> > > binary(8) data type, instead of the normal DateTime data type. Any
> > > ideas?
>
> > > Thank you in advance.
>
> > > Benj- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web
Services,.NET Remoting" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://cm.megasolutions.net/forums/default.aspx
-~----------~----~----~----~------~----~------~--~---
