ETL: ISOAddDuration

Add an ISO 8601 duration expression to an ISO datetime string and return the updated result. Use for date arithmetic in ETL pipeline expressions.

Description

Adds the value represented by the duration expression to the datetime_string.

Syntax

ISOAddDuration(datetime_string, duration)

Arguments

datetime_string - string expression in ISO 8601 format.

duration - duration string expression in ISO 8601 format. See https://en.wikipedia.org/wiki/ISO_8601#Durations

Examples

ISOAddDuration('2007-03-05T03:05:03.000Z', 'P1D') returns 2007-03-06T03:05:03.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.