FLOOR(5.8) : FLOOR « Numerical Math Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Numerical Math Functions
  3. FLOOR
SQL> select FLOOR(5.8) from dual;

FLOOR(5.8)
----------
         5








14.12.FLOOR
14.12.1.FLOOR(x) gets the largest integer less than or equal to x.
14.12.2.Use FLOOR function to get the flooring value
14.12.3.FLOOR for negative value
14.12.4.FLOOR(5.8)
14.12.5.FLOOR(-5.2)
14.12.6.select round(345.678), ceil(345.678), floor(345.678)
14.12.7.Use floor to get the number of weeks
14.12.8.Use floor and mod to get the number of days