The FLOOR function returns the largest integer that is not greater than its argument. The data type of the return value is the same as that of the argument.
FLOOR( number_operand )
--it returns the largest integer less than or equal to the arguments
SELECT FLOOR(34567.34567), FLOOR(-34567.34567);
floor(34567.34567) floor(-34567.34567)
============================================
34567.00000 -34568.00000
SELECT FLOOR(34567), FLOOR(-34567);
floor(34567) floor(-34567)
=============================
34567 -34567