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时间段查询
原文:https://www.cnblogs.com/fishness/p/14498151.html