小数位数"/>
Oracle 11g sum求和后显示完整的小数位数
select sum(222.3300+11.2200) from dual;
结果:233.55
期望:233.5500
解决一:
select trim(to_char(sum(222.3300+11.2200),999999990.9999)) from dual;
结果:233.5500
解决二:
CAST()函数:cast( 列名/值 as 数据类型 )
select cast(sum(22.000+11.000) as decimal(10,4)) as sumdecfrom dual;
更多推荐
Oracle 11g sum求和后显示完整的小数位数
发布评论