在SQL Server中两个小时的时差

试试这个： 模式：

create table a(Starttime time,Endtime time)

INSERT INTO a VALUES ('23:00:00','19:00:00')
INSERT INTO a VALUES ('09:00:00','19:00:00')
INSERT INTO a VALUES ('23:00:00','07:00:00')

查询：

select Starttime,Endtime,
 CASE WHEN datediff(HOUR,Starttime,Endtime)<0 THEN 24+datediff(HOUR,Starttime,Endtime) 
      ELSE datediff(HOUR,Starttime,Endtime) END Diff
FROM A

输出：

|        Starttime |          Endtime | Diff |
|------------------|------------------|------|
| 23:00:00.0000000 | 19:00:00.0000000 |   20 |
| 09:00:00.0000000 | 19:00:00.0000000 |   10 |
| 23:00:00.0000000 | 07:00:00.0000000 |    8 |