上一次写的未能满足包含查询,这次补上
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)