Dear all,

I have come across this problem:

Database version: 8.1.7
Client: 9i

When I issue a query like below from the client:

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

it returns no rows, although the records do exist.

The records only appear if I change query like this:

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

why is this so??? can someone explain this?

Is there any settings needed to be corrected?

Thanks in advance.