sql时间段查询 

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'
)

 

posted @ 2021-03-08 10:01  fishness  阅读(590)  评论(0)    收藏  举报