表字段为int类型
CASE WHEN MyRequiredPeriod IS NULL THEN '-' ELSE CAST(ROUND(MyRequiredPeriod/3600,1) AS NVARCHAR(50)) END,这样取出来的小数后面带0,怎样才让能让这个字段取得两位小数呢
CASE WHEN MyRequiredPeriod IS NULL THEN '-' ELSE CAST(ROUND(MyRequiredPeriod/3600,2) AS NVARCHAR(50)) END
cast(13.145 as decimal(10, 2))