Description
Resets the ISO datetime string to the beginning of the hour specified in the string.Syntax
ISOToHour(datetime_string)
Examples
ISOToHour('2009-01-07T01:07:01.000Z') returns 2009-01-07T01:00:00.000Z
Functions A to Z
ETL: ISOToHour
Truncate an ISO datetime string to the start of its hour. Use ISOTOHOUR for hourly aggregations and time bucketing in ETL pipeline expressions.
Last modified on April 20, 2026