ADD_MONTHS()

Add Months Syntax:

The return type is always DATE Example — ADD A MONTH USE ADD_MONTHS() SELECT ADD_MONTHS(CURRENT_DATE,1) AS NEXT_MONTH_DATE FROM DUAL;

ADD_MONTHS() Read More ยป