SELECT TRUNCATE(545,-2); : TRUNCATE « Math Numeric Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Math Numeric Functions
  3. TRUNCATE
mysql>
mysql>
mysql> SELECT TRUNCATE(545,-2);
+------------------+
| TRUNCATE(545,-2) |
+------------------+
|              500 |
+------------------+
1 row in set (0.00 sec)








21.36.TRUNCATE
21.36.1.TRUNCATE(X,D) returns the number X, truncated to D decimal places.
21.36.2.TRUNCATE(1.999,0);
21.36.3.TRUNCATE(-1.999,1);
21.36.4.TRUNCATE(122,-2);
21.36.5.TRUNCATE(10.28*100,0);
21.36.6.SELECT TRUNCATE(545,-2);