AND trunc(o1.book_time) >= TRUNC(to_date('2013-09-04 00:00:00','YYYY-MM-DD hh24:mi:ss'))
AND trunc(o1.book_time) <= TRUNC(to_date('2013-09-04 00:00:00','YYYY-MM-DD hh24:mi:ss'))
AND trunc(o1.book_time) >= TRUNC(to_date('2013-09-04 00:00:00','YYYY-MM-DD hh24:mi:ss'))
AND trunc(o1.book_time) <= TRUNC(to_date('2013-09-04 00:00:00','YYYY-MM-DD hh24:mi:ss'))