René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

months_between [Oracle SQL]

months_between (date-1, date-2)
Calculates the numbers of months between date-1 and date-2. The returned value can be a fractional or negative.
select months_between (date '2002-03-04', date '2002-04-14') from dual;
-1.3225806

Links