Description
Substracts the value represented by the duration expression from the datetime_string.
Syntax
ISOSubtractDuration(datetime_string, duration)
Arguments
datetime_string - string expression in ISO 8601 format.
duration - duration string in ISO 8601 format. See https://en.wikipedia.org/wiki/ISO_8601#Durations
Examples
ISOSubtractDuration('2007-03-05T03:05:03.000Z', 'P1D') returns 2007-03-04T03:05:03.000Z
Notes
The datetime_string must be in ISO 8601 date time format, otherwise the job will fail.
Return value datatype
String
Impact of null value
If input is null, returns null.