Date/Time Datatypes
Date/Time
Datatypes in SQL
Server (Transact-SQL):
Data Type Syntax
|
Maximum Size
|
Explanation
(if applicable) |
DATE
|
Values range from '0001-01-01' to
'9999-12-31'.
|
Displayed as 'YYYY-MM-DD'
|
DATETIME
|
Date values range from '1753-01-01
00:00:00' to '9999-12-31 23:59:59'.
Time values range from '00:00:00' to '23:59:59:997' |
Displayed as 'YYYY-MM-DD
hh:mm:ss[.mmm]'
|
DATETIME2(fractional seconds precision)
|
Date values range from '0001-01-01'
to '9999-12-31'.
Time values range from '00:00:00' to '23:59:59:9999999'. |
Displayed as 'YYYY-MM-DD
hh:mm:ss[.fractional seconds]'
|
SMALLDATETIME
|
Date values range from '1900-01-01'
to '2079-06-06'.
Time values range from '00:00:00' to '23:59:59'. |
Displayed as 'YYYY-MM-DD hh:mm:ss'
|
TIME
|
Values range from '00:00:00.0000000'
to '23:59:59.9999999'
|
Displayed as 'YYYY-MM-DD
hh:mm:ss[.nnnnnnn]'
|
DATETIMEOFFSET(fractional seconds precision)
|
Date values range from '0001-01-01'
to '9999-12-31'.
Time values range from '00:00:00' to '23:59:59:9999999'. Time zone offset range from -14:00 to +14:00. |
Displayed as 'YYYY-MM-DD
hh:mm:ss[.nnnnnnn]' [{+|-}hh:mm]
|
No comments:
Post a Comment