Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.6.1
Description
MariaDB:
SELECT ADD_MONTHS('1994-07-07', 2);
|
+-----------------------------+
|
| ADD_MONTHS('1994-07-07', 2) |
|
+-----------------------------+
|
| 1994-09-07 |
|
+-----------------------------+
|
 |
SELECT ADD_MONTHS('1994-07-07', 2.6);
|
+-------------------------------+
|
| ADD_MONTHS('1994-07-07', 2.6) |
|
+-------------------------------+
|
| 1994-10-07 |
|
+-------------------------------+
|
Oracle:
SELECT ADD_MONTHS('07-JUL-1994',2) FROM DUAL
|
ADD_MONTHS('07-JUL-1994',2.6)
|
07-SEP-94
|
|
SELECT ADD_MONTHS('07-JUL-1994',2.6) FROM DUAL
|
ADD_MONTHS('07-JUL-1994',2)
|
07-SEP-94
|
Is this intentional? Also, no warnings.
Attachments
Issue Links
- relates to
-
MDEV-20025 ADD_MONTHS() Oracle function
- Closed