sql时间表示

[selg1984]

sql怎么表示夜间的20点到第二天6点
DrivingPoint 开始时间
ArrivalPoint 结束时间

如何查找 DrivingPoint 在夜晚20点 到ArrivalPoint 第二天6点
谢谢

[还在加载中灬]

SELECT * FROM TB
WHERE CONVERT(VARCHAR(5),DATEADD(HOUR,-7,DrivingPoint),108)>='13:00'
	AND DATEDIFF(HOUR,CONVERT(VARCHAR(10),DATEADD(HOUR,-7,DrivingPoint),120)+' 20:00',ArrivalPoint)<=10

[lzw_0736]

SELECT * 
FROM TB
WHERE DATEPART(hh,DrivingPoint)>=20 AND DATEPART(hh,ArrivalPoint)<=6

[dovei]

1楼复杂，2楼明显出不来

SELECT * 
FROM TB
WHERE (DATEPART(hh,DrivingPoint) BETWEEN 20 AND 23 or DATEPART(hh,DrivingPoint) BETWEEN 0 AND 6)