TRUNC

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.

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

Was this article helpful?