Important
New database features are no longer connected to engine versions; features are now enabled independently during scheduled update windows, and “major” and “minor” releases no longer exist in Helios. Please visit the release notes to view the latest features available in your database clusters.
FORMAT
On this page
The FORMAT() function 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.,
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 |
+---------------------+Last modified: