Mega Code Archive

 

Categories / MySQL Tutorial / Math Numeric Functions

 

FLOOR(X) returns the largest integer value not greater than X

mysql> mysql> SELECT FLOOR(1.23); +-------------+ | FLOOR(1.23) | +-------------+ |           1 | +-------------+ 1 row in set (0.00 sec) mysql> SELECT FLOOR(-1.23); +--------------+ | FLOOR(-1.23) | +--------------+ |           -2 | +--------------+ 1 row in set (0.02 sec) mysql>