ETL: ISOToWeek

Truncate an ISO datetime string to Monday of its week. Use ISOTOWEEK for weekly aggregations and reporting in Integrate.io ETL data pipelines.

Description

Resets the ISO datetime string to the beginning of the week (Monday) specified in the string.

Syntax

ISOToWeek(datetime_string)

Examples

ISOToWeek('2009-01-07T01:07:01.000Z') returns 2009-01-05T00:00:00.000Z

Notes

The datetime_string must be in ISO 8601 date time format, otherwise the job will fail. See Using ISO 8601 date/time functions.

Return value datatype

String

Impact of null value

If input is null, returns null.