Use FLOOR in MySQL : Floor Ceiling « Math « SQL / MySQL

1. SQL / MySQL
2. Math
3. Floor Ceiling

Use FLOOR in MySQL

/*
mysql> select FLOOR(12.345);
+---------------+
| FLOOR(12.345) |
+---------------+
|            12 |
+---------------+
1 row in set (0.00 sec)

mysql> select FLOOR(-12.3456);
+-----------------+
| FLOOR(-12.3456) |
+-----------------+
|             -13 |
+-----------------+
1 row in set (0.00 sec)


*/  
select FLOOR(12.345);

select FLOOR(-12.3456);
           
       

Related examples in the same category