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

See also add_months, last_day, months_between, next_day.