SQL时间重合 包含 交叉

上一次写的未能满足包含查询，这次补上

 SELECT *   FROM ERP_Support_date esd  WHERE (esd.support_start_date BETWEEN        to_date('2013-04-03 23:00', 'yyyy-MM-dd hh24:mi') AND        to_date('2013-04-04 20:30', 'yyyy-MM-dd hh24:mi') OR        esd.support_end_date BETWEEN        to_date('2013-04-03 23:00', 'yyyy-MM-dd hh24:mi') AND        to_date('2013-04-04 20:30', 'yyyy-MM-dd hh24:mi') OR        to_date('2013-04-03 23:00', 'yyyy-MM-dd hh24:mi') Between        esd.support_start_date AND esd.support_end_date OR        to_date('2013-04-04 20:30', 'yyyy-MM-dd hh24:mi') BETWEEN        esd.support_start_date AND esd.support_end_date)