Data grid displays a blank data when running a query against a date column.
For e.g. CREATE TABLE mydate( non_empty_date date not null );
select * from mydate;
The result of the above select statement shows a blank data for the table's date column.
Defect confirmed. Toad for Oracle may not be displaying data of type date if the value is in a non-standard Oracle date format
WORKAROUND 1:
In the Toad Editor, run the query below prior to the query against the table containing date column:
select sysdate from dual;
For e.g.
select sysdate from dual;
select * from mydate;
WORKAROUND 2:
Use the following statement to include type-casting on the date field in the SQL query:
select TO_CHAR(non_empty_date, 'YYYY-MM-DD HH24:MI:SS') from mydate;
STATUS:
Waiting for fix in future release for TOAD for Oracle.
