MONTHS_BETWEEN « Date Timezone « Oracle PL / SQL

1.Experimenting with MONTHS_BETWEEN
2.MONTHS_BETWEEN: number of months between two dates
3.MONTHS_BETWEEN(x, y): get the number of months between x and y.
4.MONTHS_BETWEEN: Returned result is a negative number of months
5.MONTHS_BETWEEN with to_date function
6.MONTHS_BETWEEN(SYSDATE, last_stock_date)
7.ROUND(MONTHS_BETWEEN(SYSDATE, last_stock_date),0) months_between( sysdate, date'1971-05-18' ) months_between( sysdate, date'2001-01-01' )

10.Combine Months_between, to_date, to_char together
11.Count the months between now and hired date