Mysql FLOOR
From w3cyberlearnings
Contents |
MySQL FLOOR Function
This function returns the largest value that is not greater than X.
Syntax FLOOR
X is an integer
FLOOR(X);
Example 1
mysql> SELECT FLOOR(3.9); +------------+ | FLOOR(3.9) | +------------+ | 3 | +------------+ 1 row in set (0.00 sec)
Example 2
mysql> SELECT FLOOR(-3.9); +-------------+ | FLOOR(-3.9) | +-------------+ | -4 | +-------------+ 1 row in set (0.00 sec)
