Javatpoint Logo
Javatpoint Logo

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:


MySQL Math FLOOR() Function

Example 2

Output:


MySQL Math FLOOR() Function

Example 3

Output:


MySQL Math FLOOR() Function
Next TopicMySQL Math




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA