TO_ISO8601
All functions > DATE_AND_TIME > TO_ISO8601
Returns an ISO 8601 string from the given timestamp.
Syntax
TO_ISO8601(timestamp)sql
Arguments
| Parameter | Type | Required | Description |
|---|---|---|---|
timestamp | TIMESTAMP | Yes | A TIMESTAMP value to convert |
Returns
An ISO 8601 formatted string representation
Notes
- Converts timestamp to ISO 8601 string format
- Output format: YYYY-MM-DDTHH:MM:SS
- Includes timezone information
- Useful for standardized datetime string representation
- Inverse of FROM_ISO8601_TIMESTAMP