using between in ORACLE

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');


No comments:

Post a Comment