Oracle PL/SQL Programming, Third Edition

Name

TRUNC

Synopsis

The TRUNC function truncates the first argument to the number of decimal places specified by the second argument. The specification for the TRUNC function is:

FUNCTION TRUNC (n NUMBER, [decimal_places NUMBER]) RETURN NUMBER;

The decimal_places argument is optional and defaults to 0, which means that n will be truncated to zero decimal places, a whole number. The value of decimal_ places can be less than zero. A negative value for this argument directs TRUNC to truncate or zero-out digits to the left of the decimal point rather than to the right. Here are some examples:

TRUNC (153.46) --> 153
TRUNC (153.46, 1) --> 153.4
TRUNC (-2003.16, -1) --> -2000

For a comparison of ROUND with several other numeric functions, see Table 9-7 and Figure 9-5 earlier in Section 9.3.1 .