You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

TRUNCATE

Returns the number x truncated to d decimal places.

Syntax

TRUNCATE (x, d)

Arguments

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

Return Type

Float or double.

Examples

memsql> select truncate(PI(), 5);
+-------------------+
| truncate(PI(), 5) |
+-------------------+
|           3.14159 |
+-------------------+