TRUNCATE
On this page
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
SELECT TRUNCATE(PI(), 5);
+-------------------+
| TRUNCATE(PI(), 5) |
+-------------------+
| 3.14159 |
+-------------------+Last modified: February 24, 2023