Sql 中取小数点后面两位小数
时间:2022-03-14 10:42
select convert(numeric(8,2),round(UnTaxAmount,2))as UnTaxAmount from View_SaleVoice select cast(UnTaxAmount as decimal(20,2)) as UnTaxAmount from View_SaleVoice
时间:2022-03-14 10:42
select convert(numeric(8,2),round(UnTaxAmount,2))as UnTaxAmount from View_SaleVoice select cast(UnTaxAmount as decimal(20,2)) as UnTaxAmount from View_SaleVoice