The Oracle & PLSQL ADD_MONTHS function returns a date plus n months.
ADD_MONTHS(d,n)
Example 1:
SELECT ADD_MONTHS(TO_DATE('31/10/2007','DD/MM/YYYY'),4) FROM DUAL;
returns:
29/02/2008
The Oracle & PLSQL ADD_MONTHS function returns a date plus n months.
ADD_MONTHS(d,n)
Example 1:
SELECT ADD_MONTHS(TO_DATE('31/10/2007','DD/MM/YYYY'),4) FROM DUAL;
returns:
29/02/2008