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?

Accepted Answer

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

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

Oracle Date - How to add years to date

Solution

Problem