2021-10-01

**

sql中将数字字段后面多余的0去除

**
DB2数据库

CAST(ITEM_COST AS FLOAT) as ITEMCODE

• 示例

select ITEM_COST, CAST(ITEM_COST AS FLOAT) as ITEMCODE
from FA.V_BECS_PERIOD_END_ITEM_COST
where BOOK_CODE = '3301'
  and PERIOD_NAME = '202109';

• 结果：