Range and storage requirements

Table 1-13 summarizes the range and storage requirements for the datetime, smalldatetime, bigdatetime, bigtime, date, and time datatypes:

**Table 1-13: Transact-SQL datatypes for storing dates and times**
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