[MDEV-12787] FR: Oracle Compatibility with SYSDATE Arithmetic Created: 2017-05-12 Updated: 2018-12-03 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major |
| Reporter: | Will Fong | Assignee: | Ralf Gebhardt |
| Resolution: | Unresolved | Votes: | 2 |
| Labels: | Compatibility | ||
| Description |
|
In Oracle, it is possible to perform addition (and presumably subtraction) operations against SYSDATE with the following syntax:
This will add 10 days to the current date. MariaDB requires the + INTERVAL 10 DAYS syntax, which will require query rewriting in the entire application. |