The FLOOR function returns the largest integer less than an input value that you specify.
All platforms support the SQL2003 syntax:
When you pass a positive number, the effect of FLOOR is to eliminate anything after the decimal point:
SELECT FLOOR(100.1) FROM dual;FLOOR(100.1) ------------ 100
Remember, though, that with negative numbers, going in the “less than” direction corresponds to increasingly larger absolute values:
SELECT FLOOR(-100.1) FROM dual;FLOOR(-100.1) ------------- -101
Use CEIL to get behavior opposite to FLOOR.