Data Type Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Data Type
  4. MONTHS_BETWEEN with to_date function
SQL>
SQL> SELECT MONTHS_BETWEEN(TO_DATE('22SEP2006','ddMONyyyy'),
  2    TO_DATE('13OCT2001','ddMONyyyy')) "Months difference"
  3  FROM dual;
Months difference
-----------------
       59.2903226
SQL>
SQL>
SQL>