Query rows between two times


select * from log_table
where logtime > = to_date('2015-06-01 14:12:00', 'YYYY-MM-DD HH24:MI:SS')
  AND logtime < = to_date('2015-06-30 14:20:00', 'YYYY-MM-DD HH24:MI:SS') 
  ORDER BY NO
Advertisements