Excellent point!

When you say
WHERE date_col = '8-Nov-00'
Oracle interprets that as 00:00:00 on 8-Nov-00. If you have a row that was inserted with a date/time group of 01:05 on 8-Nov-00, the row will not be selected. Pinakin's modification takes care of this problem.