datetime_add

The datetime_add function calculates a new datetime from a specified datepart multiplied by a specified amount, added to a specified datetime.

Syntax

​

    datetime_add( Period, Amount, Datetime )

Arguments

​

• Period: Possible values are: Year, Quarter, Month, Week, Day, Hour, Minute, Second, Millisecond, Microsecond, Nanosecond.
• Amount: An integer.
• Datetime: A datetime.

Returns

​

A date after a certain time/date interval has been added, represented as datetime (Unix time).

Examples

​

• year = datetime_add('year',1,make_datetime(2022,1,1))
• month = datetime_add('month',1,make_datetime(2022,1,1))
• quarter = datetime_add('quarter',1,make_datetime(2022,1,1))
• week = datetime_add('week',1,make_datetime(2022,1,1))
• day = datetime_add('day',1,make_datetime(2022,1,1))
• hour = datetime_add('hour',1,make_datetime(2022,1,1))
• minute = datetime_add('minute',1,make_datetime(2022,1,1))
• second = datetime_add('second',1,make_datetime(2022,1,1))