Details
-
Type:
Bug
-
Status: Confirmed (View Workflow)
-
Priority:
Minor
-
Resolution: Unresolved
-
Affects Version/s: 10.6.1
-
Fix Version/s: 10.6
-
Component/s: None
-
Labels:
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
-