Collections:
FORMAT_PICO_TIME() - Formatting Picoseconds in Readable Units
How to format a number of picoseconds in a human-readable unit using the FORMAT_PICO_TIME() function?
✍: FYIcenter.com
FORMAT_PICO_TIME(con) is a MySQL built-in function that
converts a number of picoseconds in a human-readable unit of ps, ns, ms,
s, min, h, or d.
For example:
SELECT FORMAT_PICO_TIME(9), FORMAT_PICO_TIME(9*1000), FORMAT_PICO_TIME(9*1000*1000); -- +---------------------+--------------------------+-------------------------------+ -- | FORMAT_PICO_TIME(9) | FORMAT_PICO_TIME(9*1000) | FORMAT_PICO_TIME(9*1000*1000) | -- +---------------------+--------------------------+-------------------------------+ -- | 9 ps | 9.00 ns | 9.00 us | -- +---------------------+--------------------------+-------------------------------+ SELECT FORMAT_PICO_TIME(9*POW(1000,3)), FORMAT_PICO_TIME(9*POW(1000,4)); -- +---------------------------------+---------------------------------+ -- | FORMAT_PICO_TIME(9*POW(1000,3)) | FORMAT_PICO_TIME(9*POW(1000,4)) | -- +---------------------------------+---------------------------------+ -- | 9.00 ms | 9.00 s | -- +---------------------------------+---------------------------------+ SELECT FORMAT_PICO_TIME(9*POW(1000,4)*60), FORMAT_PICO_TIME(9*POW(1000,4)*60*60); -- +------------------------------------+---------------------------------------+ -- | FORMAT_PICO_TIME(9*POW(1000,4)*60) | FORMAT_PICO_TIME(9*POW(1000,4)*60*60) | -- +------------------------------------+---------------------------------------+ -- | 9.00 min | 9.00 h | -- +------------------------------------+---------------------------------------+ SELECT FORMAT_PICO_TIME(9*POW(1000,4)*60*60*24); -- +------------------------------------------+ -- | FORMAT_PICO_TIME(9*POW(1000,4)*60*60*24) | -- +------------------------------------------+ -- | 9.00 d | -- +------------------------------------------+
Reference information of the FORMAT_PICO_TIME() function:
FORMAT_PICO_TIME(picoseconds): str Converts a number of picoseconds in a human-readable unit of ps, ns, ms, s, min, h, or d. Arguments, return value and availability: picoseconds: Required. The number of picoseconds to be converted. str: Return value. The converted number in a human-readable unit. Available since MySQL 8.0.
⇒ FROM_DAYS() - Converting Days to Date
⇐ EXTRACT() - Extracting Datetime Component
2025-09-24, 902🔥, 0💬
Popular Posts:
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...