TO_ISO8601

All functions > DATE AND TIME > TO_ISO8601

Returns an ISO 8601 string from the given timestamp.

Signatures

Returns: An ISO 8601 formatted string representation

TO_ISO8601(timestamp: TIMESTAMP) → VARCHAR

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

Examples

SELECT
    f1 := TO_ISO8601(TIMESTAMP '2024-03-15 10:30:00')  -- Convert timestamp to ISO 8601
;