秒化分，计算求和问题

求学boy 发布于 2007-08-14 10:23， 1133 次点击

有一个时间字段以秒为单位feevalue，现在想把他化成分，然后求和~~~~条件是feevalue在60秒一下都算一分钟，大于等于60秒按60秒一分计算，该怎么写这个SQL语句，帮忙帮忙`11谢谢了表名fee

3 回复

sky_yang_sky2007-08-14 11:27

select sum(field/60) from tablename

求学boy2007-08-14 11:43

有条件的，那样的话我还有问吗

Kendy1234562007-08-14 13:52

create table #tbl1
(
feevalue int,
minute int
)

create table #tbl2
(
feevalue int,
minute money
)

insert into #tbl1
select feevalue, feevalue / 60 from fee
insert into #tbl2
select feevalue, feevalue / 60 from fee

update #tbl1 set minute = a.minute + 1 from #tbl1 join #tbl2 on a.feevalue =b.feevalue and a.minute - b.minute <> 0

select sum(minute) from #tbl1