Date and time datatypes  Entering date and time data

Chapter 1: System and User-Defined Datatypes

Range and storage requirements

Table 1-13 summarizes the range and storage requirements for the datetime, smalldatetime, 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

date

January 1, 0001 to December 31, 9999

4

time

12:00:00 AM to 11:59:59:999 PM

4





Copyright © 2005. Sybase Inc. All rights reserved. Entering date and time data

View this book as PDF