返回相差的时间：

Question

表1中有两个时间字段，time1，time2、形式都是YYYY/MM/DD的，我想算算这两个时间一共相差几个小时？
xiexie!

Answer 1

datediff(hour,time2,time1)

Answer 2

select datediff(hour,time2,time1)

Answer 3

select sum(datediff(hh,time1,time2)) from 表1
这样？

Answer 4

select datediff(hour,time1,time2)

Answer 5

select datediff(hh,'2010-2-13','2010-2-20')  --168

Answer 6

select datediff(hour,time2,time1)

Answer 7

select datediff(hour,time2,time1)