truncate
Description
Syntax:
DOUBLE truncate(DOUBLE x, INT d)
This function truncates x according to the number of decimal places d.
The rules are as follows:
If d > 0: keep d decimal places of x.
If d = 0: retain the integer part of x only.
If d < 0: retain the integer part of x only, and replace d digit places in the integer part with o .
Example
mysql> select truncate(124.3867, 2);
+-----------------------+
| truncate(124.3867, 2) |
+-----------------------+
| 124.38 |
+-----------------------+
mysql> select truncate(124.3867, 0);
+-----------------------+
| truncate(124.3867, 0) |
+-----------------------+
| 124 |
+-----------------------+
mysql> select truncate(-124.3867, -2);
+-------------------------+
| truncate(-124.3867, -2) |
+-------------------------+
| -100 |
+-------------------------+Keywords
TRUNCATE