This will truncates or chops off digits of
precision from a number.
Syntax: trunc (value, precision)
Ex:
SQL> select trunc(123.2345), trunc(123.2345,2),
trunc(123.2354,2) from dual;
TRUNC(123.2345)
TRUNC(123.2345,2) TRUNC(123.2354,2)
--------------------- ----------------------- -----------------------
123 123.23 123.23
SQL> select
trunc(123.2345,-1), trunc(123.2345,-2), trunc(123.2345,-3),
trunc(123.2345,-4) from dual;
TRUNC(123.2345,-1) TRUNC(123.2345,-2)
TRUNC(123.2345,-3) TRUNC(123.2345,-4)
------------------------ ------------------------ ----------------------- ------------------------
120 100 0 0
SQL> select
trunc(123,0), trunc(123,1), trunc(123,2) from dual;
TRUNC(123,0)
TRUNC(123,1) TRUNC(123,2)
---------------- ---------------- -----------------
123 123 123
SQL> select
trunc(-123,0), trunc(-123,1), trunc(-123,2) from dual;
TRUNC(-123,0)
TRUNC(-123,1) TRUNC(-123,2)
----------------- ----------------- -----------------
-123 -123 -123
SQL> select
trunc(123,-1), trunc(123,-2), trunc(123,-3), trunc(-123,-1), trunc(
-123,2), trunc(-123,-3) from dual;
TRUNC(123,-1) TRUNC(123,-2) TRUNC(123,-3)
TRUNC(-123,-1) TRUNC(-123,2) TRUNC(-
123,-3)
------------- ------------- -------------
-------------- ------------- ---------------------------------
120 100 0 -120 -123 0
SQL> select
trunc(null,null), trunc(0,0), trunc(1,1), trunc(-1,-1), trunc(-2,-2) from
dual;
TRUNC(NULL,NULL)
TRUNC(0,0) TRUNC(1,1) TRUNC(-1,-1) TRUNC(-2,-2)
----------------------- ------------- -------------
--------------- ----------------
0 1 0 0
