Math Numeric Functions MySQL Tutorial

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