Toad World® Forums

Toad 6.5 : Some DATETIME fields not displaying the *time* component

Ran across this yesterday. Ran a query, which includes some DATETIME fields. With a time component in the raw data.

Toad grid-results refused to display the time part. Displayed the date… but no time.

Checked the date formatting, it was set to U, which normally gets everything.

Is there a way to force Toad to always display the date component?

You mean the “time” component in that last line

Hi Thomas,

Can you explain you issue again? it is better one screenshot show what you want.thanks.

Wiki.