sys Schema Stored Functions +----------------------------------------------------------+ | sys.format_statement(@stmt) | +----------------------------------------------------------+ | SELECT variable, value, set_time, set_by FROM sys_config | +----------------------------------------------------------+ mysql>  SET @sys.statement_truncate_len = 32; mysql>  SELECT sys.format_statement(@stmt); +-----------------------------------+ | sys.format_statement(@stmt) | +-----------------------------------+ | SELECT variabl ... ROM sys_config | +-----------------------------------+ 28.4.5.6 The format_time() Function Note As of MySQL 8.0.16,  format_time()  is deprecated; expect it to be removed in a future version of MySQL. Applications that use it should be migrated to use the built-in  FORMAT_PICO_TIME()  function instead. See Section 12.22, “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). Parameters Return Value Example 28.4.5.7 The list_add() Function Parameters Return Value A  TEXT  value. Adds a value to a comma-separated list of values and returns the result. 5205 • in_add_value TEXT : The value to add to the list. • in_list TEXT : The list to be modified. This function and  list_drop()  can be useful for manipulating the value of system variables such as sql_mode  and  optimizer_switch  that take a comma-separated list of values. mysql>  SELECT sys.format_time(3501), sys.format_time(188732396662000); +-----------------------+----------------------------------+ | sys.format_time(3501) | sys.format_time(188732396662000) | +-----------------------+----------------------------------+ | 3.50 ns | 3.15 m | +-----------------------+----------------------------------+ A  TEXT  value. • picoseconds TEXT : The picoseconds value to format.