Date Timestamp Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Date Timestamp Functions
  4. Subtract 13 months from the January 1, 2005
SQL>
SQL> SELECT ADD_MONTHS('01-JAN-2005', -13) FROM dual;
ADD_MONTH
---------
01-DEC-03
SQL>