SQL Server 2008 range of values for various datetime

Original: SQL Server 2008 range of values for various datetime

In addition to datetime and smalldatetime, SQL Server 2008 adds four additional time types: Date,time,datetime2 and DateTimeOffset.

Each time type range, precision list:

Data type Time range accuracy

DateTime 1753-01-01 to 9999-12-31 00:00:00 to 23:59:59.997 3.33 ms

smalldatetime 1900-01-01 to 2079-06-06 00:00:00 to 23:59:59 minutes

Date 0001-01-01 to 9999-12-31 days

Time 00:00:00.0000000 to 23:59:59.9999999 100 nanoseconds

DateTime2 0001-01-01 to 9999-12-31 00:00:00 to 23:59:59.9999999 100 nanoseconds

DateTimeOffset 0001-01-01 to 9999-12-31 00:00:00 to 23:59:59.9999999-14:00 to +14:00 100 nanoseconds

List of time-type expressions: Data type output is 12:35:29. 1234567 date 2007-05-08 smalldatetime 2007-05-08 12:35:00 datetime 2007-05-08 12:35:29.123 datetime2 2007-05-08 12:35:29. 1234567 DateTimeOffset 2007-05-08 12:35:29.1234567 +12:15

SQL Server 2008 range of values for various datetime