在性能方面,没有很好的方式来处理此问题。正确的where
声明是:
where (start <= end and :time between start and end) or
(end < start and :time not between end and start)
当然,您不必使用between
,您可以扩展它:
where (start <= end and :time >= start and :time <= end) or
(end < start and (:time <= end or :time >= start))