Details
-
Type:
Bug
-
Status: Open (View Workflow)
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 10.4.6
-
Fix Version/s: 10.4
-
Component/s: PL/SQL
-
Labels:None
-
Environment:Windows
Description
In the ORACLE-Mode there is a problem with subtract / add from dates to sysdate
e.g. in Oracle
select sysdate - 7 from dual; |
I get the value, when today is the 02.07.2019:
25.06.19 16:25:28 |
When I try this in MariaDB
select sysdate() -7; |
I get the text/number
+----------------+
|
| sysdate() -7 | |
+----------------+
|
| 20190702162697 | |
+----------------+
|
1 row in set (0.001 sec) |
correct is
+---------------------+
|
| sysdate() -7 | |
+---------------------+
|
| 2019-06-25 16:27:29 | |
+---------------------+
|
1 row in set (0.001 sec) |
The reason is that in Oracle subtractions the day is subtracted and not then seconds.