// 金额保留两位小数,多余舍掉 cast(trunc(pay_amount,2) AS NUMBER // 金额保留两位小数,四舍五入 to_char(pa.pay_amount,'fm99,999,990.00') 转载于:https://www.cnblogs.com/PinkPink/p/10673190.html