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
.
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 |
Constant |
---|---|---|---|---|
value |
string |
Required |
Only one |
Variable |
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.
Aliases¶
parseisotime
(deprecated)