Example
SELECT FLOOR(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.
Syntax
FLOOR(
number
)Parameter Values
| Parameter | Description |
|---|---|
| number | Required. A numeric value |
Technical Details
| Works in: | From MySQL 4.0 |
|---|