SQL Server supports the following date and time types.
date (Transact-SQL)
datetime (Transact-SQL)
datetime2 (Transact-SQL)
datetimeoffset (Transact-SQL)
smalldatetime (Transact-SQL)
time (Transact-SQL)
SQL Server prend en charge les types de date et d'heure suivants :