Date Timezone Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Date Timezone
  4. MONTHS_BETWEEN(x, y)
SQL>
SQL> SELECT MONTHS_BETWEEN('25-MAY-2005', '15-JAN-2005') FROM dual;
MONTHS_BETWEEN('25-MAY-2005','15-JAN-2005')
-------------------------------------------
                                 4.32258065
SQL>
SQL>
SQL>