Function documentationADD_MONTHS(t,a) Locate this document in the navigation structure


ADD_MONTHS(t,a) is a date function that determines a date in the future or a date in the past.

Value t: When used in a function, the expression t (date_or_timestamp_expression) must supply a date, a time stamp, or an alphanumeric value that matches the current date or time stamp format.

Value a: The expression a (expression) supplies a numeric value that represents a number of months. Any decimal places in a are truncated if necessary.

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


t, a

Result of the ADD_MONTHS(t,a) Function

Addition of a to t or subtraction of a from t

Date value or time stamp value

t or a is a NULL value

NULL value

a is a special NULL value

Error message