Oracle当天记录的查询
Oracle当天记录的查询
Java代码
select * from(
select t.*,rownum rn from(
select www.2cto.com
col1,
to_char(A.TestTime,'YYYY-MM-DD HH24:MI:SS') as TestTime,
from TestTable A where 1=1
lower(col1) like lower('%col1%')
TESTTIME
between to_date(#testtime1#,'YYYY-MM-DD HH24:MI:SS')
www.2cto.com
to_date(#testtime2#,'YYYY-MM-DD HH24:MI:SS') + 1 - 1/86400
order by testtime desc nulls last
) t where rownum<=#maxResult#
) where rn>#firstResult#
作者 四书五经
Oracle当天记录的查询