TRUNC (Expression)
Returns a number truncated to a certain number of decimal places.
SQL syntax
TRUNC (Expression
[,m
])
Parameters
TRUNC
has the parameters:
Parameter | Description |
---|---|
|
The |
|
The number of decimal places to truncate to. If |
Examples
SELECT TRUNC (15.79,1) FROM dual; < 15.7 > 1 row found. SELECT TRUNC (15.79,-1) FROM dual; < 10 > 1 row found.