Datetime minimum and maximum values

The following table describes minimum and maximum values for the datetime types.

Table 2-38: Datetime minimum and maximum values

Datatype

Minimum value

Maximum value

CS_BIGDATETIME

January 1, 0001 00:00:00.000000

December 31, 9999 23:59:59.999999

CS_BIGTIME

00:00:00.000000

23:59:59.999999

CS_DATE

January 1, 0001

December 31, 9999

CS_DATETIME

January 1, 1753 00:00:00.000

December 31, 9999 23:59:59.999

CS_DATETIME4

January 1, 1900 00:00:00.000

June 6, 2079 23:59:59.999

CS_TIME

00:00:00.000

23:59:59.999