Outdated Version

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

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