ADD_MONTH takes a date, from either an information or in ISO8601 format, and a number of months to add, and returns a date with the given number of months added.

Example: Date

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

This returns 2001-07-01T00:00:00, 18 months after the 1st January 2000.

Example: Date with time

If you specify not just a date, but a date and time in ISO8601 format, the function includes the time in the calculation.

ADD_MONTHS('2001-07-01T09:35:23', 18)

This returns also the 18th January 2000, but at 9:35:23, so 2001-07-01T09:35:23.

Last updated