Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO problem date and time fields
Message
From
02/05/2000 13:43:28
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00364980
Message ID:
00365214
Views:
23
>When you use the OLE-DB Provider for ODBC, I beleive empty dates are returned as 12/30/1899 12:00:00 AM. If you have a blank date in a VFP Cursor and you query that value from the ADO Recordset, this is the date you get.
>
Do you know why they would choose this date for an (ODBC return) "empty" date? MS seems to have little rhyme or reason on this, e.g. the "empty" date in Outlook being 1/1/4501.
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.
Previous
Reply
Map
View

Click here to load this message in the networking platform