FORMAT
Rounds and formats a number with thousands separators and a fixed-length decimal part.
Syntax
FORMAT ( expression, precision )
Arguments
expression: any valid numeric expression.
precision: the number of digits after the decimal to pad or round to.
Return Type
String. The thousands separator is hard-coded to “,” and the decimal separator is “.”
Examples
SELECT FORMAT(1234.565, 2); **** +---------------------+ | FORMAT(1234.565, 2) | +---------------------+ | 1,234.57 | +---------------------+
SELECT FORMAT(1234.56499, 2); **** +------------------------+ | FORMAT(1234.561499, 2) | +------------------------+ | 1,234.56 | +------------------------+
SELECT FORMAT(1234.567, 0); **** +---------------------+ | FORMAT(1234.567, 0) | +---------------------+ | 1,235 | +---------------------+