Toad World® Forums

Toad Data Point displays nulls for records that have values


#1

I have seen this before. My result grid is displaying null for dates that have values in them. My query even filters for where date is not null yet all of the results show null. Has anyone else ever experienced this?

SQL:

Select patient, visit_dte, birthtime

from visit table

where visit_dte is not null

;

The result set in Toad Data Point shows all nulls, but when I run in Sql Developer they all show dates as expected.