ADD_MONTHS

= ADD_MONTHS Function Arguments: ADD_MONTHS( date, number of months you want to add ) Description : This function adds months to a date. Examples: > FROM f_staffs > FROM employees > FROM dual =
 * SELECT last_name, first_name, birthdate, ADD_MONTHS(BIRTHDATE,9)
 * SELECT last_name, first_name, hire_date, ADD_MONTHS(HIRE_DATE,3)
 * SELECT SYSDATE,ADD_MONTHS(SYSDATE, 5)