[RESOLVED] mssql 2005 dates

[brin351]

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.

[dee-u]

Perhaps as nvarchar?

[jmcilhinney]

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#.

[brin351]

Ok thank you both for your input.