MySQL TRUNCATE()

TRUNCATE(X, D)

 

Returns the number X, truncated to D decimal places. If D is 0, the result has no decimal point or fractional part. D can be negative to cause D digits left of the decimal point of the value X to become zero.

 

 

mysql> SELECT TRUNCATE(1.223, 1);
+--------------------+
| TRUNCATE(1.223, 1) |
+--------------------+
|                1.2 |
+--------------------+
1 row in set (0.00 sec)

 

mysql> SELECT TRUNCATE (1.999, 1);
+---------------------+
| TRUNCATE (1.999, 1) |
+---------------------+
|                 1.9 |
+---------------------+
1 row in set (0.00 sec)

 

mysql> SELECT TRUNCATE(1.999, 0);
+--------------------+
| TRUNCATE(1.999, 0) |
+--------------------+
|                  1 |
+--------------------+
1 row in set (0.00 sec)

 

mysql> SELECT TRUNCATE(-1.999, 1);
+---------------------+
| TRUNCATE(-1.999, 1) |
+---------------------+
|                -1.9 |
+---------------------+
1 row in set (0.00 sec)

 

mysql> SELECT TRUNCATE(122, -2);
+-------------------+
| TRUNCATE(122, -2) |
+-------------------+
|               100 |
+-------------------+
1 row in set (0.00 sec)