select
case
when ( l.accountflag = '1' or l.accountflag = '2' ) then
(
to_char(l.salerate,'fm9999999990.00')
)
else
(
''
)
end
from atzorder t left join atzloanappinfo l on l.id = t.eloaninfoid
直接 to_char 的话
0.3 会变成 .3
select
case
when ( l.accountflag = '1' or l.accountflag = '2' ) then
(
to_char(l.salerate,'fm9999999990.00')
)
else
(
''
)
end
from atzorder t left join atzloanappinfo l on l.id = t.eloaninfoid
直接 to_char 的话
0.3 会变成 .3