DATE
Casts a string value to a date.
Syntax
DATE(value)
Arguments
| Name | Type | Description | Default Value |
|---|---|---|---|
| value | timestamp |
Returns
date
Examples
| value | Output |
|---|---|
| "2022-02-01" | date "2022-02-01" |
| timestamp "2022-02-01 00:00:00" | date "2022-02-01" |
| timestamp "2022-01-01 00:30:00" | date "2022-01-01" |