Returned result is a negative number of months : MONTHS_BETWEEN « Date Timestamp Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Date Timestamp Functions
  3. MONTHS_BETWEEN
SQL>
SQL> SELECT MONTHS_BETWEEN('15-JAN-2005', '25-MAY-2005') FROM dual;

MONTHS_BETWEEN('15-JAN-2005','25-MAY-2005')
-------------------------------------------
                                 -4.3225806

SQL>








13.10.MONTHS_BETWEEN
13.10.1.MONTHS_BETWEEN(x, y): get the number of months between x and y.
13.10.2.Returned result is a negative number of months
13.10.3.Use the MONTHS_BETWEEN function
13.10.4.SELECT MONTHS_BETWEEN('15-JAN-2005', '25-MAY-2005')
13.10.5.months_between current time and birthday
13.10.6.Months between birthday and now