Oracle PL/SQL - Date type ADD_MONTHS function

  1. HOME
  2. Oracle PL/SQL
  3. PL SQL Data Type
  4. DATE data type in PL/SQL

Introduction

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

 v_dt:= ADD_MONTHS(date,integer);

declare
    v_dt DATE;
    v_form_tx VARCHAR2(25):=
                     'DD-MON-YYYY HH24:MI:SS';
begin
  --adds one month to the current day.
  v_dt:=add_months(sysdate,1);                                      
  DBMS_OUTPUT.put_line(to_char(v_dt,v_form_tx));
  --adds one month to January 30
  v_dt:=add_months(to_date('030130','RRMMDD'),1); --8
  DBMS_OUTPUT.put_line(to_char(v_dt,v_form_tx));
end;
/

Related Topic