Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
From 30/12/1899 but what about under?
Message
 
 
To
05/10/2006 00:52:08
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Miscellaneous
Thread ID:
01159585
Message ID:
01159614
Views:
17
>Ok, I adjusted all my empty VFP date values to be 30/12/1899 00:00:00. Now, I can have the package to understand that and import the records. But, I have an ancestral tree of martial arts masters in that table so we have birth date going up to the 14th century. So, one of my date is 01/01/1417 00:00:00. And, of course, the package cannot understand that as it is lower than 30/12/1899. What now?

In SQL Server unknow dates are usualy represented by NULLs. In MS SQL Server the minimum date that can be stored in the datetime data type is January 1, 1753
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform