TRUNC
Returns a numeric value, rounded to the specified length or precision and then truncated to the appropriate number of places.
Note: This function is equivalent to ROUND in T-SQL, with a third argument
(function) of 1.
Return Value
Numeric
Syntax
TRUNC( numExpr, length )
where:
- numExpr is the numeric expression containing the value you want to have rounded and then truncated.
- length indicates the number of places or the precision to which the number should be rounded and then truncated.
When length is a positive number, numExpr is rounded to the number of decimal positions specified by length. When length is a negative number, numExpr is rounded on the left side of the decimal point, as specified by length.