Date Timestamp Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Date Timestamp Functions
  4. Returned result is a negative number of months
SQL>
SQL> SELECT MONTHS_BETWEEN('15-JAN-2005', '25-MAY-2005') FROM dual;
MONTHS_BETWEEN('15-JAN-2005','25-MAY-2005')
-------------------------------------------
                                 -4.3225806
SQL>