TO_ISO8601()
All functions > DATE AND TIME > TO_ISO8601()
Converts a DATE or TIMESTAMP to an ISO 8601 datetime string.
Signatures
Timestamps and dates
Returns: An ISO 8601 formatted datetime string
TO_ISO8601(value: DATE | TIMESTAMP) → VARCHARsql
| Parameter | Type | Required | Description |
|---|---|---|---|
value | `DATE | TIMESTAMP` | Yes |
Signature notes:
- Output pattern:
YYYY-MM-DDTHH:MM:SS - DATE inputs produce a string with a midnight time component (e.g.
2024-03-15T00:00:00) - Inverse of
FROM_ISO8601_TIMESTAMPwhen the string matches that format
Examples
Dates
FeatureQL
SELECT
f1 := TO_ISO8601(DATE '2024-03-15') -- Date produces midnight time component
;Result
| f1 VARCHAR |
|---|
| 2024-03-15T00:00:00 |
Timestamps
FeatureQL
SELECT
f1 := TO_ISO8601(TIMESTAMP '2024-03-15 10:30:00'), -- Mid-day wall-clock time
f2 := TO_ISO8601(TIMESTAMP '2024-01-02 00:00:00') -- Midnight
;Result
| f1 VARCHAR | f2 VARCHAR |
|---|---|
| 2024-03-15T10:30:00 | 2024-01-02T00:00:00 |
Intervals
FeatureQL
SELECT
f1 := TO_ISO8601(INTERVAL '1 day 4 hours 5 minutes 6 seconds'), -- Day + time components
f2 := TO_ISO8601(INTERVAL '30 minutes'), -- Pure time duration
f3 := TO_ISO8601(INTERVAL '0 seconds') -- Zero interval
;Result
| f1 VARCHAR | f2 VARCHAR | f3 VARCHAR |
|---|---|---|
| P1DT4H5M6S | PT30M | PT0S |