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.