Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-6222

Mysql does not have to_char function

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Invalid
    • 1.36.0
    • None
    • None

    Description

      mysql> select to_char(timestamp '2002-04-20 17:31:12.66', 'HH12:MI:SS')
    -> ;
ERROR 1305 (42000): FUNCTION test.to_char does not exist

      mysql does not seem to have a to_char function

       

      link：https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_date-format

      Attachments

        Issue Links

          is caused by

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-5619 Support PostgreSQL's TO_CHAR function

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

          Web Link GitHub Pull Request #3645

          Activity

            People

              Unassigned Unassigned
              caicancai Caican Cai
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: