suifeng 发表于 2013-1-13 18:46:38

db2 round 不完整实现

select case
         when BUDGET_AMOUNT = 0 then
          '0.000000'
         else
          trim(to_char(BUDGET_AMOUNT / 10000, '999999999.999999'))
       end
  from MB_BUDGETDETAIL
页: [1]
查看完整版本: db2 round 不完整实现