只要有一个时间在此区间内就符合
SELECT starttime,endtime FROM businessapply WHERE
deptguid = '1'
and ( '2022-02-22'<=endtime and '2022-02-24'>=starttime)
or('2022-02-22'>endtime and '2022-02-24'<starttime)
只要有一个时间在此区间内就符合
SELECT starttime,endtime FROM businessapply WHERE
deptguid = '1'
and ( '2022-02-22'<=endtime and '2022-02-24'>=starttime)
or('2022-02-22'>endtime and '2022-02-24'<starttime)