ROUND(150.000,2)/ROUND(150,2) : ROUND « Math Numeric Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Math Numeric Functions
  3. ROUND
mysql>
mysql> SELECT ROUND(150.000,2), ROUND(150,2);
+------------------+--------------+
| ROUND(150.000,2) | ROUND(150,2) |
+------------------+--------------+
|           150.00 |       150.00 |
+------------------+--------------+
1 row in set (0.01 sec)

mysql>








21.31.ROUND
21.31.1.ROUND(X), ROUND(X,D) rounds the argument X to D decimal places.
21.31.2.ROUND(1.298, 1)
21.31.3.ROUND(1.298, 0)
21.31.4.ROUND(23.298, -1)
21.31.5.ROUND(150.000,2)/ROUND(150,2)
21.31.6.Rounding value in a column
21.31.7.How rounding differs for exact and approximate values: