`

日期段交叉

 
阅读更多

SELECT * FROM `t_order` where
(('2008-01-08'>=startDate) and ( '2008-01-03'<=startDate)) or
(('2008-01-03'<=endDate) and ('2008-01-08'>=endDate)) or
 (('2008-01-03'>=startDate) and ('2008-01-08')<=endDate)

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics