Sorry, I should have added something. If you want to get all rows between 2 dates A and B (which may or may not include time components), then your query can be like this:
where date_col >= trunc(to_date(A,'...'))
and date_col < trunc(to_date(B,'...')) + 1