HUMANIZE_NUMBER

Returns a readable number.

Syntax

HUMANIZE_NUMBER(x);

Arguments

Return Type

String.

Examples

SELECT HUMANIZE_NUMBER(1000 * 1000)
+-------------------------+
| HUMANIZE_NUMBER((1000 * 1000)) |
+-------------------------+
| 1 million               |
+-------------------------+