Oracle PL/SQL – FLOOR function example
The FLOOR() function round the specified number down, and return the largest number that is less than or equal to the specified number. FLOOR function examples SELECT FLOOR(1.2) FROM DUAL; — output : 1 SELECT FLOOR(1.5) FROM DUAL; — output : 1 SELECT FLOOR(1.7) FROM DUAL; — output : 1 SELECT FLOOR(1.99) FROM DUAL; — …