Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
Returns the number x truncated to d decimal places. This is similar to the TRUNC function, except that the precision (d) is required.
TRUNCATE (x, d)
Float or double.
SELECT TRUNCATE(PI(), 5);
****
+-------------------+
| TRUNCATE(PI(), 5) |
+-------------------+
| 3.14159 |
+-------------------+