MONTHS_BETWEEN: number of months between two dates : MONTHS_BETWEEN « Date Timezone « Oracle PL / SQL






MONTHS_BETWEEN: number of months between two dates

  

SQL>
SQL> --If you need the number of months, you need to use this function.
SQL>
SQL> --The syntax for the function is:
SQL>
SQL> --MONTHS_BETWEEN(date1, date2)
SQL>
SQL>
SQL> SELECT MONTHS_BETWEEN('01-JAN-01','01-AUG-01') AS MONTHS_BETWEEN FROM Dual;

MONTHS_BETWEEN
--------------
            -7

           
         
    
  








Related examples in the same category

1.Experimenting with MONTHS_BETWEEN
2.MONTHS_BETWEEN(x, y): get the number of months between x and y.
3.MONTHS_BETWEEN: Returned result is a negative number of months
4.MONTHS_BETWEEN with to_date function
5.MONTHS_BETWEEN(SYSDATE, last_stock_date)
6.ROUND(MONTHS_BETWEEN(SYSDATE, last_stock_date),0)
7.select months_between( sysdate, date'1971-05-18' )
8.select months_between( sysdate, date'2001-01-01' )
9.Combine Months_between, to_date, to_char together
10.Count the months between now and hired date