Table 1-13 summarizes the range and storage requirements for the datetime, smalldatetime, 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
date
January 1, 0001 to December 31, 9999
time
12:00:00 AM to 11:59:59:999 PM
View this book as PDF