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

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.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            woqutech.com woqutech.com added a comment -

            The patch is implement add_months funcions using Item_date_add_interval(thd, $3, $5, INTERVAL_MONTH, 0), please review the patch, thanks!

            woqutech.com woqutech.com added a comment - The patch is implement add_months funcions using Item_date_add_interval(thd, $3, $5, INTERVAL_MONTH, 0), please review the patch, thanks!
            monty Michael Widenius added a comment -

            I looked at the patch and it looks ok.
            I will push it in to bb-10.6-monty today and into 10.6 next week

            monty Michael Widenius added a comment - I looked at the patch and it looks ok. I will push it in to bb-10.6-monty today and into 10.6 next week

            People

              monty Michael Widenius
              Faisal Faisal Saeed (Inactive)
              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.