Adds days to a timestamp or a tselements.

The ADDDAYS function consumes from the top of the stack a number (positive or negative) of days, a time parameter (timestamp or tselements) and optionally a timezone parameter. It adds the days and when an optional timezone is specified the computation is performed using it instead of UTC. Timezone names are the ones defined in Joda Time.

This function will take into account leap years and, when working with timestamps, possible daylight saving time change.

ADDDAYS is available since version 1.2.0.

See also



// 2018-03-24 22:00:39Z 1521928839 STU * 'NOW' STORE $NOW 5 ADDDAYS $NOW -2 ADDDAYS $NOW 'Europe/Paris' 5 ADDDAYS $NOW 'Europe/Paris' TSELEMENTS 5 ADDDAYS $NOW TSELEMENTS 5 ADDDAYS