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 TRUNCATE function except that the precision (d) is not required. If the precision is not specified, the number is truncated to 0 decimal places.
If you do not specify a format, and if your value is not numeric, it will be treated like a date.
TRUNC(x [,d])
Float or double.
SELECT TRUNC(PI());
****
+-------------+
| TRUNC(PI()) |
+-------------+
| 3 |
+-------------+
SELECT TRUNC(42.422, 1);
****
+------------------+
| TRUNC(42.422, 1) |
+------------------+
| 42.4 |
+------------------+