Details
-
Technical task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.6
Description
This function is used to add / subtract months from a given date/datetime value.
It's very similar to DATE_ADD() function in MariaDB.
MariaDB: DATE_ADD(sysdate(), interval 5 months)
Oracle: ADD_MONTHS(sysdate, 5)
Oracle Doc: https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions004.htm
Attachments
Issue Links
- relates to
-
MDEV-25752 ADD_MONTHS with a non-integer argument gives a different result on Oracle compared to MariaDB
- Closed