Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

MONTHS_BETWEEN(x, y)

Returned result is a positive number of months SQL> SELECT MONTHS_BETWEEN('25-MAY-2005', '15-JAN-2005') FROM dual; MONTHS_BETWEEN('25-MAY-2005','15-JAN-2005') -------------------------------------------                                  4.32258065 SQL>