Thanks for repying.
I am using the autogenerated query that we get when we select a table.
SQL SELECT *
It throws error.
But if I select a single field all records are fetched.
date(T$INVD,'DD-MMM-YYYY') as "T$INVD";
where T$INVD >= '01-JAN-2012';
I have tried fetching all date fields by same method but again 0 rows are fetched.
May be I am missing something.
Formatting all fields might get us to the result but that won't be a generic solution since we have many tables each with multiple date fields.