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

Toad for SQL Server
1

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?

2

You mean the “time” component in that last line

3

Hi Thomas,

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

Wiki.