Adding two months to current date
SQL> SQL> SQL> -- Adding two months to SYSDATE. SQL> SELECT ADD_MONTHS(SYSDATE,2) from DUAL; ADD_MONTH --------- 31-OCT-06