Oracle PL/SQL Floor Function

The Floor function allows you to round down any number to the nearest integer.

The Floor Function syntax:

floor( number )

Example:

Select floor(98.97) From dual; 
98

Select floor(-98.97) From dual;
-99

Select floor(17.2) From dual;
17

Select floor(-17.2) From dual;
-18