Outdated Version

You are viewing an older version of this section. View current production version.


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])


  • x: the number to be truncated
  • d: the number of decimal places

Return Type

Float or double.


SELECT trunc(PI());
| TRUNC(PI()) |
|           3 |
SELECT TRUNC(42.422, 1);
| TRUNC(42.422, 1) |
|             42.4 |