sql 截位问题

Question

TO_CHAR(A,'FM99,999,999,999,999.99')如果A是个整数是，检索出来的值会有个点，怎么能把点去掉呢？

Answer 1

TO_CHAR(A,replace('FM99,999,999,999,999.99','.','')) 

Answer 2

rtim(TO_CHAR(A,'FM99,999,999,999,999.99'),'.')

Answer 3

REPLACE(TO_CHAR(A,'FM99,999,999,999,999.99'),'.','')

Answer 4

拼写错了，修正下
rtrim(TO_CHAR(A,'FM99,999,999,999,999.99'),'.')

Answer 5

可以统一给出两位小数啊，不一定要去掉。
TO_CHAR(1234,'FM99,999,999,999,999.00')

Answer 6

用replace的话就把小数的小数点也去了