📣
TiDB Cloud Premium is now in public preview. Unlimited growth, instant elasticity, advanced security for enterprise workloads. Try it out →

HUMANIZE_NUMBER



Returns a readable number.

Syntax

HUMANIZE_NUMBER(x);

Arguments

ArgumentsDescription
xThe numerical size.

Return Type

String.

Examples

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

Was this page helpful?