DATE Type
The DATE data type is used to store calendar dates in a structured format. It typically includes year, month, and day values, but excludes time components. The default format is YYYY-MM-DD.
Syntax
DATE
No additional parameters are required.
Limits
The range of dates supported is June 23 -5877641 CE to July 11 +5881580 CE.
Literals
Date literals are written in string format using single quotes sql DATE ('...'):
DATE '2025-02-05' DATE '2000-01-01' DATE '1999-12-31'