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

            Assignee:
            bar Alexander Barkov
            Reporter:
            danblack Daniel Black
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration