ROUND

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: February 24, 2023

Was this article helpful?