Math Numeric Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Math Numeric Functions
  4. How rounding differs for exact and approximate values
mysql>
mysql> SELECT ROUND(2.5), ROUND(25E-1);
+------------+--------------+
| ROUND(2.5) | ROUND(25E-1) |
+------------+--------------+
|          3 |            2 |
+------------+--------------+
1 row in set (0.00 sec)
mysql>