Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ODBC -- convert empty date into {30/12/1899}..
Message
From
21/01/2003 03:01:37
 
 
To
20/01/2003 04:36:34
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00743388
Message ID:
00743666
Views:
9
>>Hi,
>>
>>I am using the ODBC (USER DSN ) , it automatically convert the empty date into {30/12/1899}. Please you have the solution of this problem?
>>
>>thanks,
>>
>>Mobeen.
>
>Mobeen,
>For ODBC there is no empty date. Dates are calculated as numbers where integer part holds the days as offsett from {30/12/1899} and decimal part keeps the time as fractions of the day. An empty value defaults to 0 and it corresponds to base date {30/12/1899}.
>You can't have an empty date but a null. In your backend set date field to accept null.
>Cetin

Cetin,
Thank a lot!!!
Previous
Reply
Map
View

Click here to load this message in the networking platform