content_image/841505.jpg
## 28.4.5.6 The format_time() Function 

+----------------------------------------------------------+ | 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 | +-----------------------------------+ 

<img src='content_image/841505.jpg'>

## 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 

• picoseconds TEXT : The picoseconds value to format. 

A TEXT  value. 

mysql> SELECT sys.format_time(3501), sys.format_time(188732396662000); +-----------------------+----------------------------------+ | sys.format_time(3501) | sys.format_time(188732396662000) | +-----------------------+----------------------------------+ | 3.50 ns | 3.15 m | +-----------------------+----------------------------------+ 

Adds a value to a comma-separated list of values and returns the result. 

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. 

## Parameters 

## Return Value 

• in_list TEXT : The list to be modified. 

• in_add_value TEXT : The value to add to the list. 

A TEXT  value. 

