How do you store dates outside the range of sql servers date datatypes (specified below)
datetime - January 1, 1753, through December 31, 9999
smalldatetime - January 1, 1900, through June 6, 2079
Thanks.
Printable View
How do you store dates outside the range of sql servers date datatypes (specified below)
datetime - January 1, 1753, through December 31, 9999
smalldatetime - January 1, 1900, through June 6, 2079
Thanks.
Perhaps as nvarchar?
If you can switch to SQL Server 2008 then you have the datetime2 data type, which goes all the way back to #1/01/0001 00:00:00 AM#.
Ok thank you both for your input.