ISOSubtractDuration

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.