Oracle® Database SQL Reference 10g Release 1 (10.1) Part Number B10759-01 |
|
|
View PDF |
The TRUNC
(number) function returns n
truncated to m
decimal places. If m
is omitted, then n
is truncated to 0 places. m
can be negative to truncate (make zero) m
digits left of the decimal point.
This function takes as an argument any numeric datatype or any nonnumeric datatype that can be implicitly converted to a numeric datatype. If you omit m
, then the function returns the same datatype as the numeric datatype of the argument. If you include m
, then the function returns NUMBER
.
The following examples truncate numbers:
SELECT TRUNC(15.79,1) "Truncate" FROM DUAL; Truncate ---------- 15.7
SELECT TRUNC(15.79,-1) "Truncate" FROM DUAL; Truncate ---------- 10