FROM_ISO8601_TIMESTAMP
All functions > DATE_AND_TIME > FROM_ISO8601_TIMESTAMP
Returns a timestamp from the given ISO 8601 string.
Syntax
FROM_ISO8601_TIMESTAMP(string)sql
Arguments
| Parameter | Type | Required | Description |
|---|---|---|---|
string | VARCHAR | Yes | An ISO 8601 formatted timestamp string |
Returns
A TIMESTAMP value parsed from the ISO 8601 string
Notes
- Parses ISO 8601 formatted datetime strings
- Format: YYYY-MM-DDTHH:MM:SS or YYYY-MM-DD HH:MM:SS
- Supports timezone information in the input string
- Returns NULL if the string is not valid ISO 8601 format
- Useful for converting standardized datetime strings to timestamps