大姐求助：select to_char(0.5) from dual 结果是.5 ,如何得到0.5，前面有个零？

Question

用哪个函数可能做到？谢谢各位回答。

Answer 1

select to_char(0.5123,'0.00') from dual 

Answer 2

select to_char(0.54555,'0.0') from dual 
如果是0.55555， 会四舍五入的

Answer 3

我来说明下用格式符'9999'或'000'，0为空位补0，9为不补
SQL> select to_char(999.12345,'00000.9999') from dual;TO_CHAR(999.12345,'00000.9999'
------------------------------
 00999.1235SQL> select to_char(999.12345,'99999.9999') from dual;TO_CHAR(999.12345,'99999.9999'
------------------------------
   999.1235SQL> select to_char(999.12345,'99999.999') from dual;TO_CHAR(999.12345,'99999.999')
------------------------------
   999.123

Answer 4

SQL>  select to_char(0.5,90.9) from dual;TO_CH
-----
  0.5SQL> 

Answer 5

正解,但如果是整数的话后面有.0
select to_char(5,90.9) from dual
---------
1   5.0

Answer 6

select to_char(0.5, 'FM990.999') from dual

Answer 7

select to_char(0.5,'0.0') from dual