The format_time function converts a time value in picoseconds into a human-readable string with appropriate units (e.g., ms, s, min).
sys.format_time(picoseconds)format_time is a available with the . Given a time in picoseconds, returns a human-readable time value and unit indicator. Unit can be:
ps - picoseconds
ns - nanoseconds
us - microseconds
ms - milliseconds
This function is very similar to the function introduced in , but with the following differences:
Represents minutes as m rather than min.
Represent weeks.
This page is licensed: CC BY-SA / Gnu FDL
m - minutes
h - hours
d - days
w - weeks
SELECT
sys.format_time(43) AS ps,
sys.format_time(4321) AS ns,
sys.format_time(43211234) AS us,
sys.format_time(432112344321) AS ms,
sys.format_time(43211234432123) AS s,
sys.format_time(432112344321234) AS m,
sys.format_time(4321123443212345) AS h,
sys.format_time(432112344321234545) AS d,
sys.format_time(43211234432123444543) AS w;
+-------+---------+----------+-----------+---------+--------+--------+--------+---------+
| ps | ns | us | ms | s | m | h | d | w |
+-------+---------+----------+-----------+---------+--------+--------+--------+---------+
| 43 ps | 4.32 ns | 43.21 us | 432.11 ms | 43.21 s | 7.20 m | 1.20 h | 5.00 d | 71.45 w |
+-------+---------+----------+-----------+---------+--------+--------+--------+---------+