_add_days

Returns the timestamp with time zone (as a string) that results from adding "integer_expression" number of days to "string_expression", where "string_expression" represents a timestamp with time zone.

Syntax

_add_days ( string_expression , integer_expression )

Example 1

# _add_days ( '2005-11-01 12:00:00.000-05:00' , -1 ) #

Result

2005-10-31 12:00:00.000000000-05:00

Example 2

# _add_days ( $current_timestamp , 1 ) #

Result

2005-11-02 12:00:00.000000000-05:00

Example 3

# timestampMask ( _add_days ( $current_timestamp , 1 ) ,
 'yyyy-mm-dd' ) #

Result

2005-11-02