Floor - MySQL Command

Definition: Floor is used to round a number down to the last whole number. Any number with even the highest decimal is rounded down. This is the opposite of Ceiling which rounds everything up.

Also Known As: Round number down

Examples:

SELECT FLOOR(-3.14);

This would round down to -4

SELECT FLOOR(3.14);

This would round down to 3