Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

SELECT ADD_MONTHS(01-JAN-2005, 3) FROM dual

SQL>  SELECT ADD_MONTHS('01-JAN-2005', 3)  FROM dual; ADD_MONTH --------- 01-APR-05 SQL>