sql server中时间归不到这个时间段里，求解决

Question

CASE
WHEN
CONVERT(varchar(20),checkTime,120) >=
convert(varchar(20), DateAdd(hh, 8 , dateadd(week,datediff(week,0,checkTime),2) ) ,120)
AND CONVERT(varchar(20),checkTime,120)<
convert(varchar(20), DateAdd(hh, 8 , dateadd(week,datediff(week,0,checkTime),2) )+7 ,120)

THEN 

convert(varchar(20), DateAdd(hh, 8 , dateadd(week,datediff(week,0,checkTime),2) ) ,120)
+'~'+
convert(varchar(20), DateAdd(hh, 8 , dateadd(week,datediff(week,0,checkTime),2) )+7 ,120)
ELSE ''
END chetime

checkTime为数据库日期字段

不晓得有些日期为神魔归不到时间段里，求解决

Answer 1

你week和hh的值是多少
你这里只做了一个case when then的判断，else直接赋0了，也没有多个判断，也没有循环，那可不只能匹配一小段时间吗，只要时间落到这个时间外面就会输出空字符串