Date and time types
Applies to:
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
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)