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






  1. Oracle PL / SQL
  2. Numeric Math Functions
  3. FLOOR

round(345.678), ceil(345.678), floor(345.678)

  

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








Related examples in the same category

1.FLOOR(x): Returns the largest integer less than or equal to x
2.FLOOR: Returns the floor value (next lowest integer below number)
3.Use floor(), mod() and date calculation to show how many weeks and days an employee has been working here