Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

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>