Skip to main content
Version: Latest-3.3

round, dround

Description

Rounds a number to a specified number of digits.

  • If n is not specified, x is rounded to the nearest integer.
  • If n is specified, x is rounded to n decimal places. If n is negative, x is rounded to the left of the decimal point. If overflow occurs, an error is returned.

Syntax

ROUND(x [,n]);

Parameters

x: the number to be rounded. It supports the DOUBLE and DECIMAL128 data types.

n: the number of decimal places to round the number to. It supports the INT data type. This parameter is optional.

Return value

  • If only x is specified, the return value is of the following data type:

    ["DECIMAL128"] -> "DECIMAL128"

    ["DOUBLE"] -> "BIGINT"

  • If both x and n are specified, the return value is of the following data type:

    ["DECIMAL128", "INT"] -> "DECIMAL128"

    ["DOUBLE", "INT"] -> "DOUBLE"

Examples

mysql> select round(3.14);
+-------------+
| round(3.14) |
+-------------+
| 3 |
+-------------+

mysql> select round(3.14,1);
+----------------+
| round(3.14, 1) |
+----------------+
| 3.1 |
+----------------+

mysql> select round(13.14,-1);
+------------------+
| round(13.14, -1) |
+------------------+
| 10 |
+------------------+

mysql> select round(122.14,-1);
+-------------------+
| round(122.14, -1) |
+-------------------+
| 120 |
+-------------------+

mysql> select round(122.14,-2);
+-------------------+
| round(122.14, -2) |
+-------------------+
| 100 |
+-------------------+

mysql> select round(122.14,-3);
+-------------------+
| round(122.14, -3) |
+-------------------+
| 0 |
+-------------------+