declare @i int select @i=68 select @i/60+case when @i%60<=30 then 0.5 else 1 end
测试 当 @i=68 declare @i int select @i=68 select @i/60+case when @i%60<=30 then 0.5 else 1 end 结果 --- 1.5 当 @i=91 declare @i int select @i=91 select @i/60+case when @i%60<=30 then 0.5 else 1 end 结果 ---- 2.0
declare @i int
select @i=68
select @i/60+case when @i%60<=30 then 0.5 else 1 end
当 @i=68
declare @i int
select @i=68
select @i/60+case when @i%60<=30 then 0.5 else 1 end
结果
---
1.5
当 @i=91
declare @i int
select @i=91
select @i/60+case when @i%60<=30 then 0.5 else 1 end
结果
----
2.0