compare date with time

[svk]

Then nothing else can be simpler :

select * from your_table
where your_date_column between to_date('12-DEC-2001 070000','DD-MON-YYYY HH24MISS') and to_date('13-DEC-2001 070000','DD-MON-YYYY HH24MISS');