Table 1-13 summarizes the range and storage requirements for the datetime, smalldatetime, bigdatetime, bigtime, date, and time datatypes:
Datatype |
Range |
Bytes of storage |
---|---|---|
datetime |
January 1, 1753 through December 31, 9999 |
8 |
smalldatetime |
January 1, 1900 through June 6, 2079 |
4 |
bigdatetime |
January 1, 0001 to December 31, 9999 |
8 |
bigtime |
12:00:00.000000AM to 11:59:59.999999PM |
8 |
date |
January 1, 0001 to December 31, 9999 |
4 |
time |
12:00:00 AM to 11:59:59:990 PM |
4 |