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; (2)
SQL>  SELECT ADD_MONTHS('01-JAN-2005', -3)  FROM dual;
ADD_MONTH
---------
01-OCT-04