ISOAddDuration

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.