--如果是这个时间区段要完全包括生效日期到失效日期的时间段,那么这样 select * from t where QUERY_START_DATE<=START_DATE and QUERY_END_DATE>=END_DATE);--如果只要部分包括 select * from t where not (QUERY_START_DATE>=END_DATE or QUERY_END_DATE<=START_DATE);
生效日期大于起止日期和失效日期小于截止日期SELECT * FROM TAB WHERE START_DATE>START_DATE AND END_DATE <QUERY_END_DATE;
startdate<=query_enddate and enddate>=query_startdate
select * from t where QUERY_START_DATE<=START_DATE and QUERY_END_DATE>=END_DATE);--如果只要部分包括
select * from t where not (QUERY_START_DATE>=END_DATE or QUERY_END_DATE<=START_DATE);
生效日期大于起止日期和失效日期小于截止日期SELECT * FROM TAB WHERE START_DATE>START_DATE AND END_DATE <QUERY_END_DATE;