ADD_MONTHS#

Functionality: #

This Oracle function will return a date plus the number of months indicated.

Parameters:#

Date The starting date
NumMonths How many months you want to add to the starting date

Returns: #

Date

Errors:#

None

Operations: #

be aware that the date returned will be a valid calendar date. For example, 30-Jan-2008 plus 1 month is 29-Feb-2008

Example:#

ADD_MONTHS(~,6) will add six months to the date supplied.


Notes #

Click to create a new notes page