Edit

Date and time types

  • Article
  • 2 minutes to read

Applies to: SQL Server (all supported versions) 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)