round 函数
作用: 四舍五入
gbase> select ROUND(3.1415),ROUND(3.1415,3);
+---------------+-----------------+
| ROUND(3.1415) | ROUND(3.1415,3) |
+---------------+-----------------+
| 3 | 3.142 |
+---------------+-----------------+
1 row in set (Elapsed: 00:00:00.00)
floor 函数
floor 向下取函数
作用:向下<= 最大取整
gbase> select floor(9.99),FLOOR(9.00);
+-------------+-------------+
| floor(9.99) | FLOOR(9.00) |
+-------------+-------------+
| 9 | 9 |
+-------------+-------------+
1 row in set (Elapsed: 00:00:00.00)
truncate 函数
作用: 按位数截取,不做四舍五入。
gbase> select truncate(456.789,0),truncate(456.789,2),truncate(456.789,-2);
+---------------------+---------------------+----------------------+
| truncate(456.789,0) | truncate(456.789,2) | truncate(456.789,-2) |
+---------------------+---------------------+----------------------+
| 456 | 456.78 | 400 |
+---------------------+---------------------+----------------------+
1 row in set (Elapsed: 00:00:00.00)