Important
Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.
ROUND
On this page
The ROUND() function rounds a number to the given precision.
Syntax
ROUND ( expression, precision )
Arguments
-
expression: any valid numeric expression.
-
precision: the number of digits after the decimal to round to.
Return Type
Float or double.
Examples
SELECT ROUND(3.14159, 0), ROUND(3.14159, 2);
+-------------------+-------------------+
| ROUND(3.14159, 0) | ROUND(3.14159, 2) |
+-------------------+-------------------+
| 3 | 3.14 |
+-------------------+-------------------+Last modified: