Edit

Date and time types

  • Article
  • 2 minutes to read

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)