日付/時刻型Date and time types

適用対象: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

SQL ServerSQL Server では、以下の日付および時刻の型がサポートされています。supports the following date and time types.

このセクションの内容In 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)

参照See also

日付と時刻のデータ型および関数 (Transact-SQL)Date and Time Data Types and Functions (Transact-SQL)
AT TIME ZONE (Transact-SQL)AT TIME ZONE (Transact-SQL)