MS SQL datetime up to 1/1/1900

Question

Is it possible to save a date value up to 1-1-1900 in a column other than varchar? Or I really need to overcome this and run my own datetime library for date differences, sorting, etc.

Yes, I understand how datetime is actually stored (an integer value from a specific date), but I remember that there was another workaround from a few years ago. Now it’s just slipping away.

Answer 1

smalldatetime vs. datetime!

http://msdn.microsoft.com/en-us/library/ms187819.aspx

http://msdn.microsoft.com/en-us/library/ms182418.aspx

!

Answer 2

Yes, the DateTime type SQL Server can store dates from January 1, 1753.

Answer 3

SQL Server 2008 has a DATE data type that can range from 0001-01-01 to 9999-12-31.

In previous versions, your SOL is if you need a date before 1753-01-01 (minimum value for DATETIME).