SEARCH

 

MONTHS_BETWEEN Function

MONTHS_BETWEEN returns an integer specfiying the number of months between two dates.

The result can be either positive or negative depending on which date is greater.

Example:

SELECT MONTHS_BETWEEN(10-JAN-2036', '10-JAN-2004' ) AS RESULT FROM DUAL;

RESULT
-------------------
384

Add your comments or share tips on MONTHS_BETWEEN

 

Top