As of MySQL 8.0.16,
format_time()
is deprecated
and subject to removal in a future MySQL version.
Applications that use it should be migrated to use the
built-in FORMAT_PICO_TIME()
function instead. See
Section 14.21, “Performance Schema Functions”
Given a Performance Schema latency or wait time in
picoseconds, converts it to human-readable format and returns
a string consisting of a value and a units indicator.
Depending on the size of the value, the units part is
ps
(picoseconds), ns
(nanoseconds), us
(microseconds),
ms
(milliseconds), s
(seconds), m
(minutes),
h
(hours), d
(days), or
w
(weeks).
mysql> SELECT sys.format_time(3501), sys.format_time(188732396662000);
+-----------------------+----------------------------------+
| sys.format_time(3501) | sys.format_time(188732396662000) |
+-----------------------+----------------------------------+
| 3.50 ns | 3.15 m |
+-----------------------+----------------------------------+