四舍五入,向上取整,向下取整

oracle:

四舍五入:round(1.123,2) = 1.12

向上取整:ceil(1.123) = 2

向下取整:floor(1.123) = 1

posted @ 2018-07-21 14:00  anjunshuang  阅读(537)  评论(0编辑  收藏  举报