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

Add support for Oracle TO_DATE()

    XMLWordPrintable

Details

    • A new function TO_DATE() has been added for compatibility with other DBMS systems. in addition to the already existing STR_TO_DATE(), which is using a different format string.

    Description

      Implement TO_DATE(VARCHAR2 [DEFAULT return_value ON CONVERSION ERROR], VARCHAR2)

      https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/TO_DATE.html

      This could be implemented by reusing the code of str_to_date(), but using another version
      of extract_date_time()

      Attachments

        Issue Links

          blocks

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34569 Oracle compatibility project 4

          • Major - Major loss of function.
          • Open
          is part of

          Task - A task that needs to be done. MDEV-19162 Some basic datatypes and functions in oracle compatibility mode do not work

          • Major - Major loss of function.
          • Open
          has action item

          DOCS-5934 Loading...

          links to

          Web Link Oracle docs: Working in a Global Environment

          Web Link Oracle docs: Language names for the nlsparam argument

          Activity

            People

              monty Michael Widenius
              austinrutherford Austin Rutherford (Inactive)
              Votes:
              0 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.