MySQL FLOOR() Function

The floor() is a Math function of MySQL. This function is used to find the greatest integer which is equal to or less than the given number.

Syntax

Parameter

Number : It is the number to find the greatest integer.

Returns

This function returns the largest integer value that is equal to or less than a number.

Example 1

Output:

Example 2

Output:

Example 3

Output: