Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

Add Negative time

SQL> SQL> SELECT TO_CHAR(TO_CHAR(ADD_MONTHS(SYSDATE, -23), 'ddMONyyyy')) "- 23 mon"   2  FROM dual; - 23 mon --------- 29JUN2005 SQL>