Oracle® Database SQL Language Reference 11g Release 2 (11.2) Part Number E17118-04 |
|
|
PDF · Mobi · ePub |
ADD_MONTHS
returns the date date
plus integer
months. A month is defined by the session parameter NLS_CALENDAR
. The date argument can be a datetime value or any value that can be implicitly converted to DATE
. The integer
argument can be an integer or any value that can be implicitly converted to an integer. The return type is always DATE
, regardless of the data type of date
. If date
is the last day of the month or if the resulting month has fewer days than the day component of date
, then the result is the last day of the resulting month. Otherwise, the result has the same day component as date
.
See Also:
Table 3-10, "Implicit Type Conversion Matrix" for more information on implicit conversionThe following example returns the month after the hire_date
in the sample table employees
:
SELECT TO_CHAR(ADD_MONTHS(hire_date, 1), 'DD-MON-YYYY') "Next month" FROM employees WHERE last_name = 'Baer'; Next Month ----------- 07-JUL-2002