Date Timestamp Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Date Timestamp Functions
  4. Add Negative time
SQL>
SQL> SELECT TO_CHAR(TO_CHAR(ADD_MONTHS(SYSDATE, -23), 'ddMONyyyy')) "- 23 mon"
  2  FROM dual;
- 23 mon
---------
29JUN2005
SQL>