[Oracle] ADD_MONTHS()

ADD_MONTHS()

1) Syntax

- ADD_MONTHS(DATE, INTEGER)

2) Purpose

- ADD_MONTHS returns the date,  date plus integer months

3) Example

3_1. Before month

select to_char(add_months(sysdate, -1),'yyyymmddhh24miss') 

from dual;

3_2. After month

select to_char(add_months(sysdate, 1),'yyyymmddhh24miss') 

from dual;