Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
Converts a value to DATE, with the same behavior as CAST(value AS DATE).
date(value)
| Name | Type | Required | Description |
|---|---|---|---|
| value | STRING, DATE or TIMESTAMP | Yes | Value to convert. STRING values must parse as dates; TIMESTAMP conversion discards the time of day. Numeric input is not accepted. |
| Property | Value |
|---|---|
| Deterministic | Yes |
| Supports window usage | No |
| Exact result | Partial (A timestamp-to-date conversion can discard its time component.) |
SELECT date('2024-03-15') AS "value";
| value |
|---|
| 2024-03-15 |
SELECT date(TIMESTAMP '2024-03-15 23:59:59') AS date_only;
| date_only |
|---|
| 2024-03-15 |