MONTHS_BETWEEN

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

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation