4,012
社区成员
发帖
与我相关
我的任务
分享
SELECT *
FROM mtime
WHERE (1 = CASE WHEN starttime < endtime THEN (CASE WHEN CONVERT(varchar(5),
getdate(), 8) BETWEEN starttime AND endtime THEN 1 ELSE 0 END)
ELSE (CASE WHEN CONVERT(varchar(5), getdate(), 8) >= starttime OR
CONVERT(varchar(5), getdate(), 8) <= endtime THEN 1 ELSE 0 END) END)
SELECT *
FROM mtime
WHERE (1 = CASE WHEN starttime < endtime THEN (CASE WHEN CONVERT(varchar(5),
getdate(), 8) BETWEEN starttime AND endtime THEN 1 ELSE 0 END)
ELSE (CASE WHEN CONVERT(varchar(5), getdate(), 8) >= starttime OR
CONVERT(varchar(5), getdate(), 8) <= endtime THEN 1 ELSE 0 END) END)