在需求所需的时候,常常会取比现在时间大或者现在时间小的数据
可参考官网:https://www.w3school.com.cn/sql/func_datediff.asp
DATEDIFF(datepart,startdate,enddate)
DATEDIFF ([second], '2020-07-05 00:00:18', StartTime)< 0 代表StartTime小于'2020-07-05 00:00:18'
DATEDIFF ([second], '2020-07-05 00:00:18', EndTime)>0 代表EndTime大于'2020-07-05 00:00:18'
select * from Table where DATEDIFF ([second], '2020-07-05 00:00:18', StartTime)< 0 and DATEDIFF ([second], '2020-07-05 00:00:18', EndTime)>0