date-and-time-types.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	dev_langs	monikerRange
Date and time types	Date and time types	MikeRayMSFT	mikeray	07/23/2017	sql	t-sql	reference	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]

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