| Parameter | Type |
|---|---|
x | decimal, double |
decimal_places | integer |
Returns: decimal
Example
query:
SELECT TRUNC(3.275, 1)results:
| trunc |
|---|
| 3.2 |
TRUNC
The mathematical function to truncate a decimal value to a given number of decimal places.
The mathematical function to truncate a decimal value to a given number of decimal places.
| Parameter | Type |
|---|---|
x | decimal, double |
decimal_places | integer |
query:
SELECT TRUNC(3.275, 1)results:
| trunc |
|---|
| 3.2 |