SingleStore Managed Service

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 |
+-------------------+