MySQL FLOOR() Function

Return the largest integer value that is less than or equal to 25.75

Definition and Usage

The FLOOR() function returns the largest integer value that is smaller than or equal to a number.

Note: Also look at the ROUND(), CEIL(), CEILING(), TRUNCATE(), and DIV functions.

FLOOR(number)

Parameter	Description
number	Required. A numeric value

Works in:	From MySQL 4.0

Return the largest integer value that is less than or equal to 25:

SELECT FLOOR(25);

Email:

Content: