ADD_MONTHS+(date)

=ADD_MONTH S=

Examples:


SELECT last_name, first_name,birthdate, ADD_MONTHS(birthdate,4) FROM f_staffs

 * LAST_NAME ||  FIRST_NAME ||  BIRTHDATE ||  ADD_MONTHS(BIRTHDATE,4) ||
 *  Doe ||  Sue ||  01-JUL-80 ||  01-NOV-08 ||
 *  Miller || Bob || <span style="font-family: 'Courier New', Courier, monospace;"> 19-MAR-79 || <span style="font-family: 'Courier New', Courier, monospace;"> 19-JUL-79 ||
 * <span style="font-family: 'Courier New', Courier, monospace;"> Tuttle || <span style="font-family: 'Courier New', Courier, monospace;">Monique || <span style="font-family: 'Courier New', Courier, monospace;"> 30-MAR-69 || <span style="font-family: 'Courier New', Courier, monospace;"> 30--JUL-69 ||

<span style="font-family: 'Courier New', Courier, monospace;">SELECT last_name, first_name,hire_date, ADD_MONTHS(hire_date,6) FROM employees
<span style="font-family: 'Courier New', Courier, monospace;"> <span style="font-family: 'Courier New', Courier, monospace;">
 * <span style="font-family: 'Courier New', Courier, monospace;"> LAST_NAME || <span style="font-family: 'Courier New', Courier, monospace;"> FIRST_NAME || <span style="font-family: 'Courier New', Courier, monospace;"> HIRE_DATE || <span style="font-family: 'Courier New', Courier, monospace;"> ADD_MONTHS(HIRE_DATE,6) ||
 * <span style="font-family: 'Courier New', Courier, monospace;"> King || <span style="font-family: 'Courier New', Courier, monospace;"> Steven || <span style="font-family: 'Courier New', Courier, monospace;"> 17-JUL-87 || <span style="font-family: 'Courier New', Courier, monospace;"> 17-DEC-87 ||
 * <span style="font-family: 'Courier New', Courier, monospace;"> Kochhar || <span style="font-family: 'Courier New', Courier, monospace;"> Neena || <span style="font-family: 'Courier New', Courier, monospace;"> 21-SEP-89 || <span style="font-family: 'Courier New', Courier, monospace;"> 21-MAR-90 ||
 * <span style="font-family: 'Courier New', Courier, monospace;"> De Haan || <span style="font-family: 'Courier New', Courier, monospace;"> Lex || <span style="font-family: 'Courier New', Courier, monospace;"> 13-JAN-93 || <span style="font-family: 'Courier New', Courier, monospace;"> 13-JUL-93 ||
 * <span style="font-family: 'Courier New', Courier, monospace;"> Whalen || <span style="font-family: 'Courier New', Courier, monospace;"> Jennifer || <span style="font-family: 'Courier New', Courier, monospace;"> 17-SEP-87 || <span style="font-family: 'Courier New', Courier, monospace;"> 17-MAR-88 ||
 * <span style="font-family: 'Courier New', Courier, monospace;"> Higgins || <span style="font-family: 'Courier New', Courier, monospace;"> Shelley || <span style="font-family: 'Courier New', Courier, monospace;"> 07-JUN-94 || <span style="font-family: 'Courier New', Courier, monospace;"> 07-DEC-94 ||
 * <span style="font-family: 'Courier New', Courier, monospace;"> Gletz || <span style="font-family: 'Courier New', Courier, monospace;"> William || <span style="font-family: 'Courier New', Courier, monospace;"> 07-JUN-94 || <span style="font-family: 'Courier New', Courier, monospace;"> 07-DEC-94 ||
 * <span style="font-family: 'Courier New', Courier, monospace;"> Zlotkey || <span style="font-family: 'Courier New', Courier, monospace;"> Eleni || <span style="font-family: 'Courier New', Courier, monospace;"> 29-JAN-00 || <span style="font-family: 'Courier New', Courier, monospace;"> 29-JUL-00 ||
 * <span style="font-family: 'Courier New', Courier, monospace;"> Abel || <span style="font-family: 'Courier New', Courier, monospace;"> Ellen || <span style="font-family: 'Courier New', Courier, monospace;"> 11-MAY-96 || <span style="font-family: 'Courier New', Courier, monospace;"> 11-NOV-96 ||
 * <span style="font-family: 'Courier New', Courier, monospace;"> Taylor || <span style="font-family: 'Courier New', Courier, monospace;"> Jonathon || <span style="font-family: 'Courier New', Courier, monospace;"> 24-MAR-98 || <span style="font-family: 'Courier New', Courier, monospace;"> 24-SEP-98 ||
 * <span style="font-family: 'Courier New', Courier, monospace;"> Grant || <span style="font-family: 'Courier New', Courier, monospace;"> Kimberly || <span style="font-family: 'Courier New', Courier, monospace;"> 24-MAY-99 || <span style="font-family: 'Courier New', Courier, monospace;"> 24-NOV-99 ||

<span style="font-family: 'Courier New', Courier, monospace;">SELECT SYSDATE, ADD_MONTHS(SYSDATE,8) FROM dual
<span style="font-family: 'Courier New', Courier, monospace;">
 * SYSDATE || ADD_MONTHS(SYSDATE,8) ||
 * 07-MAR-09 || 07-NOV-09 ||