MONTHS_BETWEEN is one of the vital Date/Time functions of Oracle. It is used to get the number of months between two mentioned dates. The MONTHS_BETWEEN function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i.
Syntax:
MONTHS_BETWEEN ( date1, date2 )
Parameters:
date1: It is used to specify the first date.
date2: It is used to specify the second date.
Example 1:
MONTHS_BETWEEN (TO_DATE ('2019/01/01', 'yyyy/mm/dd'), TO_DATE ('2019/03/14', 'yyyy/mm/dd') ) |
Output:
-2.41935483870968
Explanation:
The result will be the difference of the two dates.
Example 2:
MONTHS_BETWEEN (TO_DATE ('2019/10/01', 'yyyy/mm/dd'), TO_DATE ('2019/06/14', 'yyyy/mm/dd') ) |
Output:
3.58064516129032
Explanation:
The result will be the difference of the two dates.