TO_ISO8601

All functions > DATE_AND_TIME > TO_ISO8601

Returns an ISO 8601 string from the given timestamp.

Syntax

TO_ISO8601(timestamp)
sql

Arguments

ParameterTypeRequiredDescription
timestampTIMESTAMPYesA 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

Examples

Suggest changes to this page
Last update at: 2025/10/13 10:23:46