TRUNC(x [, y]) Returns the result of truncating x an optional y decimal places
SQL>
SQL> --TRUNC(x [, y]) Returns the result of truncating x an optional y decimal places.
--If y is omitted, x is truncated to zero decimal places. If y is negative, x is truncated to
--the left of the decimal point.
SQL>
SQL>
SQL> select TRUNC(5.75) from dual;
TRUNC(5.75)
-----------
5
SQL>
Related examples in the same category