Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
The ADD_MONTHS function returns the date that is n months after the specified date.
DATETIME
ADD_MONTHS(start_datetime, n)
A DATETIME
expression that identifies the starting date. When the day component of start_datetime is the last day of the month or when the returned month has fewer days, then the returned day component is the last day of the month. Otherwise, the day component of the returned date is the same as the day component of start_datetime. See Example 7-2, "End-of-Month Calculation".
An INTEGER
that identifies the number of months to be added to start_datetime.