Question: how to find difference between two dates in years in oracle?
Answer: So if there are two dates separated by one day, the year difference can be 1 (see select datediff(year, '20141231', '20150101') ). Need to find difference in year, if leap year the a year is of 366 days.