Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
Functions, 151 of 166
trunc_number::=
trunc_number
TRUNC
returns n
truncated to m decimal places. If m
is omitted, n
is truncated to 0 places. m
can be negative to truncate (make zero) m
digits left of the decimal point.
The following example truncate numbers:
SELECT TRUNC(15.79,1) "Truncate" FROM DUAL; Truncate ---------- 15.7
SELECT TRUNC(15.79,-1) "Truncate" FROM DUAL; Truncate ---------- 10
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|