Date Timestamp Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Date Timestamp Functions
  4. Combine ADD_MONTHS() function with To_Date
SQL>
SQL> SELECT ADD_MONTHS(TO_DATE('01-JAN-2005 19:15:26',
  2    'DD-MON-YYYY HH24:MI:SS'), 2)
  3  FROM dual;
ADD_MONTH
---------
01-MAR-05
SQL>