[SQL] 시작일~종료일 사이만 나오는 조건

ibatis로 작성함

<!-- 활동기간 검색 -->
<isNotEmpty property="startdt" >
  <isNotEmpty property="enddt" >
    AND (
      (A.WORKSTARTDT BETWEEN TO_DATE(#startdt#||' 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AND TO_DATE(#enddt#||' 23:59:59', 'YYYY-MM-DD HH24:MI:SS'))
        AND
      (A.WORKENDDT BETWEEN TO_DATE(#startdt#||' 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AND TO_DATE(#enddt#||' 23:59:59', 'YYYY-MM-DD HH24:MI:SS'))
    )
  </isNotEmpty>  
  <isEmpty property="enddt" >
    AND (
      (A.WORKSTARTDT BETWEEN TO_DATE(#startdt#||' 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AND TO_DATE('9999-12-31 23:59:59', 'YYYY-MM-DD HH24:MI:SS'))
        AND
      (A.WORKENDDT BETWEEN TO_DATE(#startdt#||' 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AND TO_DATE('9999-12-31 23:59:59', 'YYYY-MM-DD HH24:MI:SS'))
    )
  </isEmpty>
</isNotEmpty>
<isEmpty property="startdt">
  <isNotEmpty property="enddt" >
    AND (
      (A.WORKSTARTDT BETWEEN TO_DATE('1111-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AND TO_DATE(#enddt#||' 23:59:59', 'YYYY-MM-DD HH24:MI:SS'))
        AND
      (A.WORKENDDT BETWEEN TO_DATE('1111-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AND TO_DATE(#enddt#||' 23:59:59', 'YYYY-MM-DD HH24:MI:SS'))
    )
  </isNotEmpty>
</isEmpty>