Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

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>