Provide the maximum integer value that is equal to or less than 25.75.
SELECT FLOOR(25.75); |
The FLOOR() function yields the greatest integer value that is less than or equal to a given number.
Note: Also consider the ROUND(), CEIL(), CEILING(), TRUNCATE(), and DIV functions.
FLOOR(number) |
Parameter |
Description |
number |
Essential: A numerical value is necessary. |
Works in: | From MySQL 4.0 |
Provide the greatest integer value that is equal to or less than 25.
SELECT FLOOR(25); |