[Prashanti]

This seems to be a day of problems.
I gave a simple Oracle select query

select * from readertable where STATUSDATE='17-MAR-07';

It didn't return any records eve though I know there is a record. The reason I know this, is because when I searched with another query on the same table

select * from readertable where READERNO=17;

it showed the STATUSDATE as '17-MAR-07'!!!

Here's another interesting quirk . When I run a date query on another table it shows the result!!!

What am I to make of all this ????? Where is the prob???

Pleeeeeeeeeeease Help!

Thanks.

[Prashanti]

I tried giving the query like

select * from <tablename> where STATUSDATE<='17-MAR-07'

and it worked ! It gave all the rows before 17-MAR-07 but at least it gave a result !
Don't ask me why , it just did .