|Oracle9i SQL Reference
Release 2 (9.2)
Part Number A96540-01
Functions, 154 of 177
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.
The following example truncate numbers: