parse_isotime

Description

Parse a 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. Example: 2022-09-19T18:38:59.059-05:00.

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

Required

Multiple

value

string

Required

Only one

Aliases

parseisotime (deprecated)