Range and storage requirements

Table 1-12 summarizes the range and storage requirements for the datetime and smalldatetime datatypes:

**Table 1-12: 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