MariaDB starting with 10.6.0

The ADD_MONTHS function was introduced in MariaDB 10.6.0 to enhance Oracle compatibility. Similar functionality can be achieved with the DATE_ADD function.


ADD_MONTHS(date, months)


ADD_MONTHS adds an integer months to a given date (DATE, DATETIME or TIMESTAMP), returning the result.

The resulting day component will remain the same as that specified in date, unless the resulting month has fewer days than the day component of the given date, in which case the day will be the last day of the resulting month.


Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.