-- 结果:0.41349,会自动用空格将前面精度不足的位数补齐,另外,,会使用千分位补齐
select to_char(123123.413488888, '999,999,990.99999') as aa from dual;
-- 结果:0.41349,结果正常。保留5位小数
select to_char(0.413488888, 'fm999,999,990.99999') as aa from dual;
-- 结果不正常,丢失了小数点前的0
select to_char(0.413488888, 'fm999,999,999.99999') as aa from dual;
版权声明:本文为paocai_2019原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。