MONTHS_BETWEEN

    This will give difference of months between two dates.

    Syntax: months_between (date1, date2)

    Ex:

         SQL> select months_between(to_date('11-aug-1990','dd-mon-yyyy'), to_date('11-

                 jan-1990','dd-mon-yyyy')) from dual;

MONTHS_BETWEEN(TO_DATE('11-AUG-1990','DD-MON-YYYY'),TO_DATE('11-JAN-1990','DD-MON-YYYY'))

-----------------------------------------------------------------------------------------------

                                                                                        7

           SQL> select months_between(to_date('11-jan-1990','dd-mon-yyyy'), to_date('11-

                 aug-1990','dd-mon-yyyy')) from dual;

 

MONTHS_BETWEEN(TO_DATE('11-JAN-1990','DD-MON-YYYY'),TO_DATE('11-AUG-1990','DD-MON-YYYY'))

-------------------------------------------------------------------------------------------------