![]() Previous |
![]() Next |
TRUNC
shortens a numeric expression to a specified number of decimal places.
Return Value
NUMBER
Syntax
TRUNC(n1 [, n2 ])
Arguments
n1
is the numeric expression to be truncated.
n2
is the number of decimal places. A positive number truncates digits to the right of the decimal point, and a negative number replaces digits to the left of the decimal point. The default value is zero (0).
Examples
TRUNC(15.79)
returns the value 15
.
TRUNC(15.79, 1)
returns the value 15.7
.
TRUNC(15.79, -1)
returns the value 10
.