ADD_MONTHS Operation

How to use the ADD_MONTHS operation for Computed Attributes

Definition

The ADD_MONTHS operation adds days to a date.

Example

ADD_MONTHS(‘2020-03-30’, 2)

Result:
“2020-05-30”

Syntax Guide

ADD_MONTHS(date, months)

date - The date to add months to

months - The number of months you want to add to the date

add-months

Compatible Attribute Types

  • Date attributes