CAST() 函数

作用: 四舍五入
SELECT CAST('9.0' AS DECIMAL) FROM DUAL; -- 9

SELECT CAST('9.5' AS DECIMAL) FROM DUAL; -- 10

SELECT CAST('9.6' AS DECIMAL) FROM DUAL; -- 10

SELECT CAST('9.3' AS DECIMAL) FROM DUAL; -- 9

SELECT CAST('9.5' AS DECIMAL(10,3)) FROM DUAL; -- 9.500

posted @ 2019-02-20 14:05  我需要一杯水  阅读(1397)  评论(0)  编辑  收藏  举报