THE WORLD'S LARGEST WEB DEVELOPER SITE

MySQL FLOOR() Function

❮ MySQL Functions

Example

Return the largest integer value that is greater than or equal to a number:

SELECT FLOOR(25.75);
Try it Yourself »

Definition and Usage

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

Note: See also the ROUND(), CEIL(), CEILING(), TRUNCATE(), and DIV functions.

Syntax

FLOOR(number)

Parameter Values

Parameter Description
number Required. A numeric value

Technical Details

Works in: MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0, MySQL 3.23

More Examples

Example

Return the largest integer value that is greater than or equal to a number:

SELECT FLOOR(25);
Try it Yourself »

❮ MySQL Functions