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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
