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 http://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.

Feedback and Knowledge Base