ADD_MONTHS Summarized - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

ADD_MONTHS returns a new date_expression or timestamp_expression with YEAR and MONTH fields adjusted to provide a correct date, but a DAY field adjusted only to guarantee a valid date, which may not be a date you expect.

If this behavior is not acceptable for your application, use ANSI SQL:2011 DateTime interval arithmetic instead. See ANSI Interval Expressions.

ADD_MONTHS changes the DAY value of the result only to prevent reporting a nonvalid date_expression or timestamp_expression.