ADD_MONTHS

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram>>-ADD_MONTHS--(--expression--,--numeric-expression--)---------><
 

The ADD_MONTHS function returns a date that represents expression plus numeric-expression months.

expression
The argument must be an expression that returns a value of one of the following built-in data types: a date, a timestamp, a character string, or a graphic string.

If expression is a character or graphic string, it must not be a CLOB or DBCLOB and its value must be a valid string representation of a date or timestamp. For the valid formats of string representations of dates and timestamps, see String representations of datetime values.

numeric-expression
The argument must be an expression that returns a value of a built-in numeric data type with zero scale. A negative numeric value is allowed.

The result of the function is a date. If either argument can be null, the result can be null; if either argument is null, the result is the null value.

If expression is the last day of the month or if the resulting month has fewer days than the day component of expression, then the result is the last day of the resulting month. Otherwise, the result has the same day component as expression.

Example