select * from table where
(
date >= ‘2020-08-10‘ AND date <= ‘2020-08-11‘
)
OR (
date <= ‘2020-08-10‘ AND date >= ‘2020-08-11‘
)
OR (
date >= ‘2020-08-10‘ AND date <= ‘2020-08-11‘
)

sql时间段查询