ADD_MONTHS()

Description of add_months.eps follows

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;

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top