Experimenting with MONTHS_BETWEEN
SQL>
SQL> -- Experimenting with MONTHS_BETWEEN.
SQL> SELECT MONTHS_BETWEEN('25-DEC-97','02-JUN-97') "Fractional", MONTHS_BETWEEN('02-FEB-97','02-JUN-97') "Integer" from DUAL;
Fractional Integer
---------- ----------
6.74193548 -4
SQL>
Related examples in the same category