Details
-
Type:
Technical task
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.6
-
Fix Version/s: 10.6.1
-
Component/s: Server
-
Labels:
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
-
- Confirmed
-