Date and Time Types

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

SQL Server supports the following date and time types.

In This Section

date (Transact-SQL)

datetime (Transact-SQL)

datetime2 (Transact-SQL)

datetimeoffset (Transact-SQL)

smalldatetime (Transact-SQL)

time (Transact-SQL)

See Also

Date and Time Data Types and Functions (Transact-SQL)
AT TIME ZONE (Transact-SQL)