Date Timestamp Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Date Timestamp Functions
  4. SELECT ADD_MONTHS(01-JAN-2005, 3) FROM dual
SQL>  SELECT ADD_MONTHS('01-JAN-2005', 3)  FROM dual;
ADD_MONTH
---------
01-APR-05
SQL>