General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only