Date and Time Types

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)