如果你的到期时间是日期类型的可以这样写: select 品号=a1,品名=a2,到期时间=a3,保质时间=a4,剩余时间=datediff(day,getdate(),a3),剩余时间比例=Cast(datediff(day,getdate(),a3)/a4 as decimal(4,2)) from A
SELECT a1 AS 品号, a2 AS 品名, a3 AS 到期时间, a4 AS 保质时间, TRUNC( TO_DATE(a3, 'YYYYMMDD') - SYSDATE ) AS 剩余时间, ( TO_DATE(a3, 'YYYYMMDD') - SYSDATE ) / a4 AS 剩余时间比例 FROM 商品表A