sql 判断两个时间段是否有重合,是否存在交集
0 条评论总结起来就一句话：最小值小于最大值并且最大值大于最小值，则一定重叠。
DECLARE @start_time DateTime
set @start_time='2024-01-23 01:09:54.000'
DECLARE @end_time DateTime
set @end_time='2024-01-26 20:09:54.000'
select * from PracticalManage
where StartDate <=@end_time and EndDate>=@start_time
