Date and Time Data Types

Use date and time data types for storing dates and times.

Syntax

Use this syntax for date and time data types.

DATE
DATETIME
SMALLDATETIME
TIME
TIMESTAMP
Parent topic: SQL Data Types
Related concepts
BIGTIME and BIGDATETIME Support
Related reference
TIMESTAMP Special Value
CURRENT TIMESTAMP Special Value
CURRENT TIME Special Value
CURRENT DATE Special Value
Retrieve Dates and Times