Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

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