Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

Adding One Month

SQL>  SELECT ADD_MONTHS(TO_DATE('31-MAR-99'),1)  from DUAL; ADD_MONTH --------- 30-APR-99 SQL>