Types date et timeDate and time types

S’APPLIQUE À : ouiSQL Server nonAzure SQL Database nonAzure Synapse Analytics (SQL DW) nonParallel Data Warehouse APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

SQL ServerSQL Server prend en charge les types de date et d'heure suivants :supports the following date and time types.

Contenu de cette sectionIn this section

date (Transact-SQL)date (Transact-SQL)
datetime (Transact-SQL)datetime (Transact-SQL)
datetime2 (Transact-SQL)datetime2 (Transact-SQL)
datetimeoffset (Transact-SQL)datetimeoffset (Transact-SQL)
smalldatetime (Transact-SQL)smalldatetime (Transact-SQL)
time (Transact-SQL)time (Transact-SQL)

Voir aussiSee also

Types de données et fonctions de date et d’heure (Transact-SQL)Date and Time Data Types and Functions (Transact-SQL)
AT TIME ZONE (Transact-SQL)AT TIME ZONE (Transact-SQL)