Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

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>