MONTHS_BETWEEN#

Functionality: #

This Oracle function will return a number that indicates the number of months between two dates.

Parameters:#

LatestDate	The latest date
EarliestDate	The earlier date

Returns: #

Number

Errors:#

None

Operations:#

This will compute a fractional number of months, and will be negative if you provide the dates in reverse.

Example:#

MONTHS_BETWEEN(SYSDATE,~) will tell you how many months from today was the date parameter passed.

---

Notes #

Click to create a new notes page