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