Write a query to find data between two time interval ?

Write a query to find data between two time interval ?

I retrieve data from this demo table (e62)

select * from e62

The Query

select * from e62
where time between
to_date('04-jun-20 4:44:31 pm','dd-mon-yy hh:mi:ss pm')
and
to_date('04-jun-20 5:44:31 pm','dd-mon-yy hh:mi:ss pm');

Output

Leave a Reply