Date and time types

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric SQL database in Microsoft Fabric

SQL Server supports the following date and time types.

In this section

• date
• datetime
• datetime2
• datetimeoffset
• smalldatetime
• time

Related content

• Date and time data types and functions (Transact-SQL)
• AT TIME ZONE (Transact-SQL)
• CAST and CONVERT (Transact-SQL)