Date Timestamp Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Date Timestamp Functions
  4. Adding One Month
SQL>  SELECT ADD_MONTHS(TO_DATE('31-MAR-99'),1)  from DUAL;
ADD_MONTH
---------
30-APR-99
SQL>