floor.txt

MariaDB [(none)]> select floor(0.3);
+------------+
| floor(0.3) |
+------------+
|          0 |
+------------+
1 row in set (0.11 sec)

MariaDB [(none)]> select floor(1.3);
+------------+
| floor(1.3) |
+------------+
|          1 |
+------------+
1 row in set (0.00 sec)

MariaDB [(none)]> select floor(1.9);
+------------+
| floor(1.9) |
+------------+
|          1 |
+------------+
1 row in set (0.00 sec)

MariaDB [(none)]> select floor(165.55);
+---------------+
| floor(165.55) |
+---------------+
|           165 |
+---------------+
1 row in set (0.00 sec)

MariaDB [(none)]> select floor(200.5);
+--------------+
| floor(200.5) |
+--------------+
|          200 |
+--------------+
1 row in set (0.00 sec)

MariaDB [(none)]> select floor(200.4);
+--------------+
| floor(200.4) |
+--------------+
|          200 |
+--------------+
1 row in set (0.00 sec)