add_months( timestamp, months )

Add a number of months to a date. The months value can be positive or negative. If the resulting date is invalid, for example, if you add one month to January 30, 2012, the date is set to the last day of the month.

Example

ts = add_months(to_date("2012-01-30", "YYYY-MM-DD"), 1)