Use cases where we need to have the result with varying are possible.

You can change the value in the resulting field using the function.

Consider the following:

Case 1: 2 decimal places

``````SELECT TRUNCATE(122.16464,2) AS VALUE;
where 122.16464 is the value and the 2 is the number of desired decimal places.

+--------+
| VALUE  |
+--------+
| 122.16 |
+--------+``````

Case 2: 1 decimal place

``````SELECT TRUNCATE(122.16464,1) AS VALUE;
where 122.16464 is the value and the 1 is the number of desired decimal places.

+--------+
| VALUE  |
+--------+
| 122.1  |
+--------+``````

Case 3: 0 decimal place

``````SELECT TRUNCATE(122.16464,0) AS VALUE;
where 122.16464 is the value and the 0 is the number of desired decimal places.

+--------+
| VALUE  |
+--------+
|    122 |
+--------+ ``````
SHARE