字符串格式:
select f.value1, to_char(f.value1,'999999999.99999') value2 from mytable f
结果:
to_char(value ,'999999999.9999') “.0000”
to_char(value ,'999999990.9999') “0.0000”
to_char(value ,'000000.0000') “001234.1230” //整数位固定
to_char(value,'999999.9999') “1234.1230” //整数位不固定
补充:FM前缀的作用是去除首尾的空字符或0
1、去掉首尾的空字符和0
2、去掉首尾的空字符,不包括0
3、未加FM
数字格式:
select f.value1, cast(f.value1 as NUMBER(10,4)) value2 from mytable f
结果:
指定小数位四舍五入:
select f.value1, round(f.value1 ,4) value2 from mytable f
结果: