Oracle Between 사용 예시

<!-- 초과근무 시간 조회 -->           
<select id="overTimeLogSelectContents" parameterType="VO" resultType="VO">
    /* VO.overTimeLogSelectContents */  
    <![CDATA[             
        SELECT 	ROUND(SUM(TO_NUMBER(A.TOTAL_HOUR)*60 + (TO_NUMBER(NVL(A.TOTAL_MIN, 0))))/60) col1
             ,	TO_CHAR(STA_DATE, 'YYYY.MM.DD') 					staDate
          FROM	t_over_add A
          LEFT 	OUTER JOIN t_over_time B
            ON 	B.USE_YN = 'Y' 
           AND 	A.OT_SEQ = B.OT_SEQ   
         WHERE	A.USE_YN = 'Y'   
           AND 	B.STATUS = 'D'  
           AND  TO_DATE(B.APPLY_DATE) BETWEEN TO_DATE(#{searchStartDate}) AND TO_DATE(#{searchEndDate})
         GROUP  BY TO_CHAR(STA_DATE, 'YYYY.MM.DD')
    ]]>     
</select>

1. 컬럼명 혹은 조회 대상 BETWEEN (시작) AND (끝)