FLOOR(x): Returns the largest integer less than or equal to x : FLOOR « Numeric Math Functions « Oracle PL / SQL






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

FLOOR(x): Returns the largest integer less than or equal to x

  

SQL> --FLOOR(x): Returns the largest integer less than or equal to x.
SQL>
SQL> select FLOOR(-5.2) from dual;

FLOOR(-5.2)
-----------
         -6

SQL>








Related examples in the same category

1.FLOOR: Returns the floor value (next lowest integer below number)
2.Use floor(), mod() and date calculation to show how many weeks and days an employee has been working here
3.round(345.678), ceil(345.678), floor(345.678)