The Oracle and PL/SQL TRUNC function returns n truncated to m decimal places.
TRUNC(n [,m])
If m is omitted, then n is truncated to 0 places.
Example 1:
SELECT TRUNC(45.1242,2) FROM DUAL;
returns:
45.12
Example 2:
SELECT TRUNC(45.8242) FROM DUAL;
returns:
45
Example 3:
SELECT TRUNC(-45.8242) FROM DUAL;
returns:
-45
Example 4:
SELECT TRUNC(45.1242,-1) FROM DUAL;
returns:
40