SQL
Date Types
<div class="narrow_table"></div>  
| Name   | Aliases | Description                     |
|:-------|:--------|:--------------------------------|
| `DATE` |         | calendar date (year, month day) |  
A date specifies a combination of year, month and day. DuckDB follows the SQL standard's lead by counting dates exclusively in the Gregorian calendar, even for years before that calendar was in use. Dates can be created using the `DATE` keyword, where the data must be formatted according to the ISO 8601 format (` YYYY-MM-DD`).  
```sql
SELECT DATE '1992-09-20';
```