SQL Floor

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