version 11
TRUNC (arithmetic_expression[, arithmetic_expression])
Description
The TRUNC function returns the first arithmetic_expression truncated to "x" places to the right of the decimal point, where "x" is the second optional arithmetic_expression. If this second arithmetic_expression is not passed, the arithmetic_expression is simply truncated by removing any decimal places.
Example
This function truncates the number passed to 1 place after the decimal point:
TRUNC(2.42 , 1) `returns 2.40
See Also