-- 结果: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;
数据库中小数点前丢了0
于 2022-01-14 18:53:43 首次发布