mysql-向上,向下,四捨五入-取整函數

標籤：mysql函數

mysql> select ceil(2.44),round(2.44),floor(2.44);
+------------+-------------+-------------+
| ceil(2.44) | round(2.44) | floor(2.44) |
+------------+-------------+-------------+
|          3 |           2 |           2 |
+------------+-------------+-------------+
1 row in set (0.00 sec)

mysql> select ceil(2.55),round(2.55),floor(2.55);     
+------------+-------------+-------------+
| ceil(2.55) | round(2.55) | floor(2.55) |
+------------+-------------+-------------+
|          3 |           3 |           2 |
+------------+-------------+-------------+
1 row in set (0.00 sec)

 

其中ceil為向上取整，round為四捨五入取整，floor為向下取整。

本文出自 “Chocolee” 部落格，請務必保留此出處http://chocolee.blog.51cto.com/8158455/1550344

mysql-向上,向下,四捨五入-取整函數