Description
Resets the ISO datetime string to the beginning of the second specified in the string.Syntax
ISOToSecond(datetime_string)
Examples
ISOToSecond('2009-01-07T01:07:01.132Z') returns 2009-01-07T01:07:01.000Z
Functions A to Z
ETL: ISOToSecond
Truncate an ISO datetime string to the start of its second. Use ISOTOSECOND for second-level precision groupings in ETL pipeline expressions.
Last modified on April 20, 2026