Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19162 Some basic datatypes and functions in oracle compatibility mode do not work
  3. MDEV-20025

ADD_MONTHS() Oracle function

    XMLWordPrintable

Details

    Description

      This function is used to add / subtract months from a given date/datetime value.

      It's very similar to DATE_ADD() function in MariaDB.

      MariaDB: DATE_ADD(sysdate(), interval 5 months)
      Oracle: ADD_MONTHS(sysdate, 5)

      Oracle Doc: https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions004.htm

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25752 ADD_MONTHS with a non-integer argument gives a different result on Oracle compared to MariaDB

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Confirmed

          Activity

            People

              monty Michael Widenius
              Faisal Faisal Saeed
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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