This will produce a whole number that is less than or equal to the
specified value.
Syntax: floor (value)
Ex:
SQL> select floor(5), floor(5.1), floor(-5), floor( -5.1), floor(0), floor(null)
from
dual;
FLOOR(5) FLOOR(5.1) FLOOR(-5) FLOOR(-5.1) FLOOR(0) FLOOR(NULL)
----------- ------------- ------------
-------------- ----------- ----------------
5 5 -5 -6 0
