SQL Tutorial SQL Advanced SQL Database SQL References

MySQL TRUNCATE() Function



The MySQL TRUNCATE() function returns a number truncated to the specified number of decimal places. If decimal_places is a negative number, this function will make digits to the left of the decimal place 0 values.

Syntax

TRUNCATE(number, decimal_places)

Parameters

number Required. Specify the number to truncate.
decimal_places Required. Specify the number of decimal places truncate to. This value must be a positive or negative integer.

Return Value

Returns the truncated value of the number to specified decimal_places.

Example 1:

The example below shows the usage of TRUNCATE() function.

mysql> SELECT TRUNCATE(1234.5678, 0);
Result: 1234

mysql> SELECT TRUNCATE(1234.5678, 1);
Result: 1234.5

mysql> SELECT TRUNCATE(1234.5678, 2);
Result: 1234.56

mysql> SELECT TRUNCATE(1234.5678, 3);
Result: 1234.567

mysql> SELECT TRUNCATE(1234.5678, -1);
Result: 1230

mysql> SELECT TRUNCATE(1234.5678, -2);
Result: 1200

Example 2:

Consider a database table called Sample with the following records:

Datax
Data 1-3.75567
Data 2-5.3867
Data 313.9804
Data 493.1601
Data 548.1322

The statement given below can be used to truncate the records of column x to 2 decimal places.

SELECT *, TRUNCATE(x, 2) AS TRUNCATE_Value FROM Sample;

This will produce the result as shown below:

DataxTRUNCATE_Value
Data 1-3.75567-3.75
Data 2-5.3867-5.38
Data 313.980413.98
Data 493.160193.16
Data 548.132248.13

❮ MySQL Functions