The Oracle and PL/SQL FLOOR function returns the largest integer value that is equal to or less than a number.
FLOOR(n)
Example 1:
SELECT FLOOR(45.1242) FROM DUAL;
45
Example 2:
SELECT FLOOR(-45.1242) FROM DUAL;
-46
Example 3:
SELECT FLOOR(45.8242) FROM DUAL;
45