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 21:41:37
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Miscellaneous
Thread ID:
01159585
Message ID:
01159986
Views:
15
>>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
>
>Is there something that can be done in our case to support those previous century dates other than to apply a design of additional fields to hold numeric values of those equivalent dates and to apply some kind of logic to extrapolate the related values where required?

Depending on how you use those dates, you can store them either as numbers or as strings.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform