在SQL里写两个时间范围有交集则成立

用于时间段的判定查询sql

参考百度

SELECT * 

FROM TEMP_TABLE

WHERE  ( ('20100626' BETWEEN start_date_time AND stop_date_time) OR ('20100628' BETWEEN start_date_time AND stop_date_time) )

	SELECT 
	  * 
	FROM
	  ym_meetingroom mr 
	  LEFT JOIN ym_meetingorder mo 
	    ON mr.id = mo.roomid 
	WHERE mr.`deleteflag` = #{deleteflag,jdbcType=INTEGER} 
	  AND mo.status != 0 
	  AND mo.status != 3 
	  AND mo.`deleteflag` = #{deleteflag,jdbcType=INTEGER} 
	  AND (
	    (
	      #{starttime,jdbcType=TIMESTAMP} BETWEEN mo.starttime 
	      AND mo.endtime
	    ) 
	    OR (
	      #{endtime,jdbcType=TIMESTAMP} BETWEEN mo.starttime 
	      AND mo.endtime
	    )
	  )