Date - Query with no rows returned -Strange !!!

[marist89]

You're not respecting the time component of the date (ie. there are no records at midnight of your date). Try:

select * from t
where trunc(date_col)>=to_date('2002/08/26','yyyy/mm/dd');