DATE
Converts a year, month, and day into a date.
Syntax
DATE(<date>)
| Parameter | Type | Description |
|---|---|---|
| date | Date | The date to strip time part. |
DATE(<year>, <month>, <day>)
| Parameter | Type | Description |
|---|---|---|
| year | Integer | The year component of the date. |
| month | Integer | The month component of the date. |
| day | Integer | The day component of the date. |
Return values
Date
Examples
DATE(1922, 7, 20)
DATE(orders.created_at)