ADD_MONTHS

Description

ADD_MONTHS takes a date and adds a specified number of months to it, returning the resulting date as a string.

Example

ADD_MONTHS('2000-01-01', 18)

This returns "2001-07-01".

Last updated

Was this helpful?