如何舍入和舍入值？ [英] How to Round up and Round-down value ?

问题描述

如何舍入和舍入值？



我有价值3.74哪个应该向下舍入到3.50和

值3.76，应该向上舍入到4.00

How to Round up and Round-down value ??

I have value 3.74 Which should be round-down to 3.50 And
value 3.76 ,which should be round-up to 4.00

推荐答案

--pass your value to @yourvalue and execute the query

declare @yourvalue decimal(4,2)
select @yourvalue = 3.75
declare @roundpart int
set @roundpart=floor(@yourvalue)
declare @des int
set @des =PARSENAME(@yourvalue,1)
if(@des>=75)
begin
 set @yourvalue= convert(decimal(4,2) ,@roundpart+1)
PRINT  @yourvalue
end
else
begin
set @yourvalue=convert(decimal(4,2), convert(varchar(10),@roundpart)+'.50')
print	@yourvalue
end

这篇关于如何舍入和舍入值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！