select round(345.678), ceil(345.678), floor(345.678) : FLOOR « Numerical Math Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Numerical Math Functions
  3. FLOOR
SQL>
SQL>
SQL> select round(345.678), ceil(345.678), floor(345.678)
  2  from   dual;

ROUND(345.678) CEIL(345.678) FLOOR(345.678)
-------------- ------------- --------------
           346           346            345

SQL>
SQL>
SQL>








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