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.
TRUNCATE
Returns the number x truncated to d decimal places. This is similar to the TRUNC function, except that the precision (d) is required.
Syntax
TRUNCATE (x, d)
Arguments
- x: the number to be truncated
- d: the number of decimal places
Return Type
Float or double.
Examples
SELECT TRUNCATE(PI(), 5);
****
+-------------------+
| TRUNCATE(PI(), 5) |
+-------------------+
| 3.14159 |
+-------------------+
