Toad World® Forums

Date columns not showing time


I can’t seem to figure this one out, I’m running the latest version of Toad. When I run a query against a table with date data type columns, Toad is only displaying the date portion of the data, not the date and time. Earlier versions of Toad I’ve used always displayed both the date and time. I can’t seem to find an option to enable this, so I’m forced to do a TO_CHAR to the column to get the date. Anyone know how to get this working?

Thanks in advance!


a few versions ago we got rid of the time portion if it was midnight. Are all of
your times midnight? If they are not, they should appear.