Date Timestamp Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Date Timestamp Functions
  4. SELECT MONTHS_BETWEEN(15-JAN-2005, 25-MAY-2005)
2   FROM dual;
MONTHS_BETWEEN('15-JAN-2005','25-MAY-2005')
-------------------------------------------
                                 -4.3225806
SQL>