date-and-time-types.md

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	ms.custom	dev_langs	monikerRange
Date and time types	Date and time types	MikeRayMSFT	mikeray	randolphwest	10/07/2024	sql	t-sql	reference	ignite-2024	TSQL	=azuresqldb-current || =azuresqldb-mi-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqledge-current || =azure-sqldw-latest || =fabric

Date and time types

[!INCLUDE sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw-fabricsqldb]

[!INCLUDE ssNoVersion] 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)