Oracle 查询当天记录

<statement id="queryTestList" resultMap="Test_Map">
    select * from(
    select t.*,rownum rn from(
  	select 
	 	col1,     
		to_char(A.TestTime,'YYYY-MM-DD HH24:MI:SS') as TestTime,       
  	from TestTable A where 1=1
  	<dynamic>
  		<isNotEmpty prepend="AND" property="col1">
  			lower(col1) like lower('%col1%')
  		</isNotEmpty>
  		<isNotEmpty prepend="AND" property="testtime1">
  			TESTTIME
between to_date(#testtime1#,'YYYY-MM-DD HH24:MI:SS')
  		</isNotEmpty>
  		<isNotEmpty prepend="AND" property="testtime2">
  			to_date(#testtime2#,'YYYY-MM-DD HH24:MI:SS') + 1 - 1/86400
  		</isNotEmpty>
  	</dynamic>
order by testtime desc nulls last
    ) t where rownum<=#maxResult#
    ) where rn>#firstResult#
  </statement>

[color=red][b]查询当天记录，主要是这一句： to_date(#testtime2#,'YYYY-MM-DD HH24:MI:SS') + 1 - 1/86400[/b][/color]