9999-12-31
|
0.00333 second
|
8
|
No
|
No
|
datetime2
|
YYYY-MM-DD hh:mm:ss[.nnnnnnn]
|
0001-01-01 00:00:00.0000000 through 9999-12-31 23:59:59.9999999
|
100 nanoseconds
|
6 to 8
|
Yes
|
No
|
datetimeoffset
|
YYYY-MM-DD hh:mm:ss[.nnnnnnn] [+|-]hh:mm
|
0001-01-01 00:00:00.0000000 through 9999-12-31 23:59:59.9999999 (in UTC)
|
100 nanoseconds
|
8 to 10
|
Yes
|
Yes
|
Note
|
The Transact-SQL rowversion data type is not a date or time data type. timestamp is a deprecated synonym for rowversion.
|
The Transact-SQL date and time functions are listed in the following tables. For more information about determinism, see
Deterministic and Nondeterministic Functions.
Functions That Get System Date and Time Values
All system date and time values are derived from the operating
system of the computer on which the instance of SQL Server is running.
Higher-Precision System Date and Time Functions
SQL Server 2008 R2 obtains the date and time values by using the
GetSystemTimeAsFileTime()
Windows API. The accuracy depends on the computer hardware and version
of Windows on which the instance of SQL Server is running. The precision
of this API is fixed at 100 nanoseconds. The accuracy can be determined
by using the
GetSystemTimeAdjustment() Windows API.
