一列的时间怎么统计

Question

本帖最后由 chirea 于 2011-06-30 22:27:35 编辑

Answer 1

SELECT numbers,
    DATEADD(second,SUM(DATEDIFF(second,0,datetimes)),0)
FROM tb
GROUP BY numbers

Answer 2

select numbers,sum(datediff(mi,'1900-01-01',datetimes)) as 分钟
from tb
group by nunbers

Answer 3

number                                             
-------------------------------------------------- -----------------------
001                                                1900-01-02 23:29:00.000
002                                                1900-01-02 07:00:10.000
003                                                1900-01-02 07:00:28.000(3 row(s) affected)number                                             datetimes
-------------------------------------------------- -----------------------
001                                                1900-01-01 00:30:00.000
001                                                1900-01-01 15:29:00.000
001                                                1900-01-01 16:00:00.000
001                                                1900-01-01 15:30:00.000
002                                                1900-01-01 15:30:00.000
002                                                1900-01-01 15:30:10.000
003                                                1900-01-01 15:30:11.000
003                                                1900-01-01 15:30:17.000(8 row(s) affected)搞定了.谢谢各位的热心