Toad World® Forums

Datetime not appears in the resultset


#1

Hello,

I have a problem with some tables because for datetime fields the time value doesn’t appear except if I click on the field.
The strange find is that for others tables the right value is showned (1/01/1970 12:00 AM).
Could you please help me ?

Thanks


#2

Hi,

DId you click on data grid in view detail or click on result grid after run query?

Could you provide your DDL script for that table to hlep us to reproduce your issue?

Thanks,
Michael.Luo@quest.com


#3


#4


#5

I click on result grid after the run of this query select top 2 * from sd.entries , like below


#6

for select top 2 * from sd.payments, I got directly the good format


#7

that’s strange

Have you check date fomat in Options->Gird->Datetime?

Michael


#8

Yes and everything seems good