Thursday, May 7, 2009

SQL Server 2008 Min and Max Date Ranges

Here are the Minimum and Maximum date ranges

SQL Server 2005
Min Date: 1753-01-01 00:00:00.000
Max Date: 9999-12-31 23:59:59.999

SQL Server 2008
Min Date: 0001-01-01 00:00:00.000
Max Date: 9999-12-31 23:59:59.999

1 comment:

Anonymous said...

Wrong. This is true vor datetime2 on SQL Server 2008. DateTime stays the same always...