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

TIME_FORMAT microsecond parsing omitted

    XMLWordPrintable

Details

    Description

      exactly same as https://bugs.mysql.com/bug.php?id=99621
      given affects MySQL-5.6 this probably applies to all versions

      part 1: Microseconds are unparsed.

      SELECT TIME_FORMAT("0:1:38:096", "%H:%i:%s:%f")
      		 
      -> "00:01:38:000000"

      part 2: Without hour ("%H") and with "%f" TIME_FORMAT returns null

      SELECT TIME_FORMAT("1:38:096", "%i:%s:%f")
      		 
      -> NULL

      https://dbfiddle.uk/?rdbms=mariadb_10.4&fiddle=3292799fc6f8674fb15f14c7b2b8eb47

      Attachments

        Activity

          People

            bar Alexander Barkov
            danblack Daniel Black
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.