SQL Functions: ADD_MONTHS

ADD_MONTHS
This function is used to add integer months to existing date. The return data type is always date function.

SELECT ADD_MONTHS (END_DATE, 1), emp  FROM EMP;

Output: Returns one month after the END_DATE for each item