parse_isotime

Description

Parse an ISO8601 (YYYY-MM-DDTHH:MM:SSZ) formatted string as a timestamp.

If its timezone is not UTC (Z), the offset must be represented as hour and minutes in ±hh:mm format. The colon between hours and minutes is required, if needed, you may do this with replace_regex.

Return type

timestamp

Domain

This is a scalar function (calculates a single output value for a single input row.)

Categories

Usage

parse_isotime(value)

Argument

Type

Optional

Repeatable

Restrictions

value

string

no

no

none

Examples

make_col timestamp:parse_isotime("2022-09-19T18:38:59.059-05:00")

Make a new time column timestamp from an ISO 8601 format date and time string.

make_col timestamp:parse_isotime(string_concat(year, "-", month, "-", day, "T", string(hour), ":", minute, ":", second, "-06:00"))

Make a new time column timestamp from a constructed time string.

make_col timestamp_ms:parse_isotime("2024-05-23T19:40:50.859Z")
make_col timestamp_mus:parse_isotime("2024-05-23T19:40:50.859394Z")
make_col timestamp_ns:parse_isotime("2024-05-23T19:40:50.859394789Z")

Make new time columns from ISO 8601 format date and time strings with sub-second precision.

Aliases

parseisotime (deprecated)