ADD_MONTHS : Date Functions « PL SQL Data Types « Oracle PL/SQL Tutorial

ADD_MONTHS function adds a number of months to the specified date:

v_dt:= ADD_MONTHS(date,integer);

SQL>
SQL> declare
  2      v_dt DATE;
  3      v_form_tx VARCHAR2(25):= 'DD-MON-YYYY HH24:MI:SS';
  4  begin
  5    v_dt:=add_months(sysdate,1);
  6    DBMS_OUTPUT.put_line(to_char(v_dt,v_form_tx));
  7    v_dt:=add_months(to_date('030130','RRMMDD'),1);
  8    DBMS_OUTPUT.put_line(to_char(v_dt,v_form_tx));
  9  end;
 10  /
09-JUL-2007 20:32:45
28-FEB-2003 00:00:00

PL/SQL procedure successfully completed.

SQL>

21.10.Date Functions
	21.10.1.	Working with dates and built-in functions EXTRACT
	21.10.2.	TRUNC and ROUND
	21.10.3.	ROUND
	21.10.4.	ADD_MONTHS
	21.10.5.	LAST_DAY
	21.10.6.	MONTHS_BETWEEN
	21.10.7.	Use TRUNC to get only the time
	21.10.8.	Returning a point just before a specific midnight with TRUNC
	21.10.9.	TO_DATE('29-DEC-1988','dd-mon-yyyy')