Below is the query which can be used to retrieve the records between two specific time intervals
select * from transactions where transactionslog
between
to_timestamp('09-may-2012'||'17:00:00','dd-mon-yyyy'||':hh24:mi:ss')
and to_timestamp('09-may-2012'||':20:00:00','dd-mon-yyyy'||':hh24:mi:ss');
select * from transactions where transactionslog
between
to_timestamp('09-may-2012'||'17:00:00','dd-mon-yyyy'||':hh24:mi:ss')
and to_timestamp('09-may-2012'||':20:00:00','dd-mon-yyyy'||':hh24:mi:ss');
No comments:
Post a Comment