oracle10g - Oracle Date - How to add years to date

Question

I have a date field

DATE = 10/10/2010

sum = 4 (this are number of years by calculation)

is there a way to add four years to 10/10/2010 and make it 10/10/2014?

question from:https://stackoverflow.com/questions/9313234/oracle-date-how-to-add-years-to-date

Answer 1

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

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