TRUNC
On this page
Returns the number x truncated to d decimal places.
If the precision is not specified, the number is truncated to 0 decimal places.
Note
If you do not specify a format, and if your value is not numeric, it will be treated like a date.
Syntax
TRUNC(x [,d])
Arguments
-
x: the number to be truncated
-
d: the number of decimal places
Return Type
Float or double.
Examples
SELECT TRUNC(PI());
+-------------+
| TRUNC(PI()) |
+-------------+
| 3 |
+-------------+SELECT TRUNC(42.422, 1);
+------------------+
| TRUNC(42.422, 1) |
+------------------+
| 42.4 |
+------------------+Last modified: April 4, 2023