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.
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: