Collections:
FORMAT_BYTES() - Formatting Bytes in Readable Units
How to format a number of bytes in a human-readable unit using the FORMAT_BYTES() function?
✍: FYIcenter.com
FORMAT_BYTES(con) is a MySQL built-in function that converts a number of bytes in a human-readable unit of KiB, MiG, GiB, TiB, PiB or EiB. For example:
SELECT FORMAT_BYTES(9), FORMAT_BYTES(9*1024), FORMAT_BYTES(9*1024*1024); -- +-----------------+----------------------+---------------------------+ -- | FORMAT_BYTES(9) | FORMAT_BYTES(9*1024) | FORMAT_BYTES(9*1024*1024) | -- +-----------------+----------------------+---------------------------+ -- | 9 bytes | 9.00 KiB | 9.00 MiB | -- +-----------------+----------------------+---------------------------+ SELECT FORMAT_BYTES(9*POW(1024,3)), FORMAT_BYTES(9*POW(1024,4)); -- +-----------------------------+-----------------------------+ -- | FORMAT_BYTES(9*POW(1024,3)) | FORMAT_BYTES(9*POW(1024,4)) | -- +-----------------------------+-----------------------------+ -- | 9.00 GiB | 9.00 TiB | -- +-----------------------------+-----------------------------+ SELECT FORMAT_BYTES(9*POW(1024,5)), FORMAT_BYTES(9*POW(1024,6)); -- +-----------------------------+-----------------------------+ -- | FORMAT_BYTES(9*POW(1024,5)) | FORMAT_BYTES(9*POW(1024,6)) | -- +-----------------------------+-----------------------------+ -- | 9.00 PiB | 9.00 EiB | -- +-----------------------------+-----------------------------+
Reference information of the FORMAT_BYTES() function:
FORMAT_BYTES(bytes): str Converts a number of bytes in a human-readable unit of KiB, MiG, GiB, TiB, PiB or EiB. Arguments, return value and availability: bytes: Required. The number of bytes to be converted. str: Return value. The converted number in a human-readable unit. Available since MySQL 8.0.
⇒ EXP() - Exponential Based on E
⇐ FORMAT() - Formatting Number to String
2023-12-19, 211🔥, 0💬
Popular Posts:
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...