Description
Resets the ISO datetime string to the beginning of the day specified in the string.Syntax
ISOToDay(datetime_string)
Examples
ISOToDay('2009-01-07T01:07:01.000Z') returns 2009-01-07T00:00:00.000Z
Functions A to Z
ETL: ISOToDay
Truncate an ISO datetime string to the start of its day (midnight UTC). Use ISOTODAY for daily grouping and aggregations in ETL data pipelines.
Last modified on April 20, 2026