Skip to main content
Version: Latest-3.2

truncate

Description​

Rounds the input down to the nearest equal or smaller value with the specified number of places after the decimal point.

Syntax​

truncate(arg1,arg2);

Parameter​

  • arg1: the input to be rounded. It supports the following data types:
    • DOUBLE
    • DECIMAL128
  • arg2: the number of places to keep after the decimal point. It supports the INT data type.

Return value​

Returns a value of the same data type as arg1.

Examples​

mysql> select truncate(3.14,1);
+-------------------+
| truncate(3.14, 1) |
+-------------------+
|               3.1 |
+-------------------+
1 row in set (0.00 sec)