Skip to main content

Description

Returns the result of a datetime_expression plus a duration string expression.

Syntax

AddDuration(datetime_expression, duration)

Arguments

datetime_expression - datetime expression. duration - duration string in ISO 8601 format. See https://en.wikipedia.org/wiki/ISO_8601#Durations

Examples

AddDuration(ToDate('2013-09-10T08:02:31.667Z'),'PT3M')returns ‘2013-09-10T08:05:31.667Z’

Return value datatype

DateTime

Impact of null value

If input is null, returns null.
Last modified on April 20, 2026