Datetime not appears in the resultset

annesophie.bada · August 30, 2018, 7:42am

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

michael · September 3, 2018, 3:18am

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

annesophie.bada · September 3, 2018, 5:01am

annesophie.bada · September 3, 2018, 5:02am

annesophie.bada · September 3, 2018, 5:03am

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

annesophie.bada · September 3, 2018, 5:06am

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

michael · September 3, 2018, 6:33am

that’s strange

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

Michael

annesophie.bada · September 3, 2018, 11:47pm

Yes and everything seems good