ADD_MONTHS macro

Syntax

Parameters

months

An integer that represents a number of months to add to the date_string.

date_string

A text string representing a valid date, in the format DELIM_M_D_Y, or in the format specified by the optional input_format argument.

input_format

The format that will be used for the calculated date. For a list of supported date formats, see the DATE_FORMAT function. Note that the input_format determines both the format of the input string and also the format of the output string.

Description

ADD_MONTHS returns a date after adding the specified number of months to the specified date_string. The date will be returned in the default format (DELIM_M_D_Y) or the format specified by the optional input_format argument. If you want a different format as the output, use DATE_FORMAT.

If increasing the month by the specified number of months produces an invalid date, then the result is calculated to be the last day of the month, as shown in the last example below. When necessary, leap years are taken into account. For example, adding one month to 31-Jan-2012 will result in 29-Feb-2012.

Examples

ADD_MONTHS(12, '06-25-11') adds one year (12 months) to the specified date and returns the date 06-25-12.

ADD_MONTHS(3, '2011-06-25', DT_DELIM_Y_M_D) adds three months to the specified date and returns the date 2011-09-25.

ADD_MONTHS(1, '02-28-2011') returns the date 03-28-2011.

ADD_MONTHS(1, '03-31-2012') returns the date 04-30-2012.

Related functions