_add_months
Returns the timestamp with time zone (as a string) that results from adding "integer_expression" number of months to "string_expression", where "string_expression" represents a timestamp with time zone.
Syntax
_add_months ( string_expression , integer_expression )Example 1
# _add_months ( '2005-11-01 12:00:00.000-05:00' , -1 ) #Result
2005-10-01 12:00:00.000000000-05:00
Example 2
# _add_months ( $current_timestamp , 1 ) #Result
2005-12-01 12:00:00.000000000-05:00
Example 3
# timestampMask ( _add_months ( $current_timestamp , 1 ) ,
'yyyy-mm-dd' ) #Result
2005-12-01