Floor function returns previous whole number. It is a Numeric Function.
Syntax :-
FLOOR(n) where n is a number
Examples :-
SQL> select floor(1.1) from dual;
FLOOR(1.1)
———-
1
SQL> select floor(1) from dual;
FLOOR(1)
———-
1
SQL> select floor(-1.1) from dual;
FLOOR(-1.1)
———–
-2
SQL> select floor(-1) from dual;
FLOOR(-1)
———-
-1
SQL> select floor(0) from dual;
FLOOR(0)
———-
0