Skip to content

utility-functions.md

Latest commit

 

History

History
42 lines (32 loc) · 960 Bytes

utility-functions.md

File metadata and controls

42 lines (32 loc) · 960 Bytes
title Utility Functions
summary This document introduces utility functions supported in TiDB.

Utility Functions

This document introduces utility functions supported in TiDB, designed to simplify common data conversions for better readability.

FORMAT_BYTES()

The FORMAT_BYTES() function converts a number of bytes into a human-readable format.

SELECT FORMAT_BYTES(10*1024*1024);
+----------------------------+
| FORMAT_BYTES(10*1024*1024) |
+----------------------------+
| 10.00 MiB                  |
+----------------------------+
1 row in set (0.001 sec)

FORMAT_NANO_TIME()

The FORMAT_NANO_TIME() function converts a number of nanoseconds into a human-readable time format.

SELECT FORMAT_NANO_TIME(1000000);
+---------------------------+
| FORMAT_NANO_TIME(1000000) |
+---------------------------+
| 1.00 ms                   |
+---------------------------+
1 row in set (0.001 sec)