Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-12787

FR: Oracle Compatibility with SYSDATE Arithmetic

    XMLWordPrintable

Details

    • New Feature
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None

    Description

      In Oracle, it is possible to perform addition (and presumably subtraction) operations against SYSDATE with the following syntax:

      SELECT SYSDATE + 10 FROM dual;
      

      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.

      Attachments

        Activity

          People

            ralf.gebhardt Ralf Gebhardt
            wfong Will Fong
            Votes:
            2 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.