The following table describes minimum and maximum values for the datetime types.
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 |