ADD_MONTHS

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

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