snomadj (3/22/2016)

---

So I no very little of Oracle:

col is a date datatype. There's something about the way Oracle is dealing with this type that I am not understanding.

If I go:

SELECT col FROM tab WHERE date <= '07-Feb-15'

I get 100 + rows.

SELECT col FROM tab WHERE date <= '06-Feb-15'

I get 0+ rows.

SELECT col FROM tab WHERE date = '07-Feb-15'

I get 1 rows.

How do I select all the 7-Feb-15 rows?

Thank you!