Oracle Date - How to add years to date

Use add_months

Example:

SELECT add_months( to_date('10-OCT-2010'), 48 ) FROM DUAL;

Warning
add_months, returns the last day of the resulting month if you input the last day of a month to begin with.

So add_months(to_date('28-feb-2011'),12) will return 29-feb-2012 as a result.

Try adding months (12 * number of years) instead. Like this-

add_months(date'2010-10-10', 48)

Related