Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

Adding Two Months to SYSDATE

SQL>  SELECT ADD_MONTHS(SYSDATE,2)  from DUAL; ADD_MONTH --------- 02-AUG-07 SQL> SQL> SELECT ADD_MONTHS(SYSDATE,2.654) from DUAL; ADD_MONTH --------- 02-AUG-07 SQL>