format_time

Syntax

sys.format_time(picoseconds)

Description

format_time is a stored function available with the Sys Schema. 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
• s - seconds
• m - minutes
• h - hours
• d - days
• w - weeks

Examples

SELECT 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;
+---------+----------+-----------+---------+--------+--------+--------+---------+
| ns      | us       | ms        | s       | m      | h      | d      | w       |
+---------+----------+-----------+---------+--------+--------+--------+---------+
| 4.32 ns | 43.21 us | 432.11 ms | 43.21 s | 7.20 m | 1.20 h | 5.00 d | 71.45 w |
+---------+----------+-----------+---------+--------+--------+--------+---------+