I still see toad misrepresenting timestamps… example 6pm
Instead of 2016-04-27-18.00.00.000000
It displays it as 2016-04-27-06.00.00.000000
This makes it look like 6 am… but since timestamp does not show PM/AM then you cant tell what the correct time is.
This is in 6.0 and i believe was still issue in 6.2 Beta.
I filed a ticket on this 8 months ago.
Herb Vogel | Product Manager
479.361.7665 (O) | 479.466.6383 © | 479.361.7973 (F)
J.B. Hunt Transport, Inc. | What’s your nextmove?™
Single Source | Intermodal | Dedicated | Final Mile | Truckload | LTL | Refrigerated | Flatbed
From: “Jeff Podlasek” bounce-Jeff_Podlasek@toadworld.com
Date: 04/28/2016 03:22 PM
Subject: RE: [Toad for IBM DB2 - Discussion Forum] Toad misinterprets Date according the date format chosen in the Tools -> Options
RE: Toad misinterprets Date according the date format chosen in the Tools -> Options
Reply by Jeff Podlasek
I have not been able to recreate this.
Can you send me the DDL for the table you are using and an export file with some of that table’s data.
When exporting can you run a select from each column and also include casting to CHAR your date columns such as:
SELECT COL1, COL2, COL3, CHAR(COL3) AS CHAR_COL3 FROM TABLE
Also send your xls file that was created in Toad’s Export wizard.
What version of Toad are you running?
What version\platform of DB2?
If this gets complex or too cumbersome - I recommend opening up a support ticket.
Thanks - Jeff
To reply, please reply-all to this email.
Stop receiving emailson this subject.
Or Unsubscribe from Toad for IBM DB2 - Generalnotifications altogether.
Toad for IBM DB2 - Discussion Forum
Flagthis post as spam/abuse.
Email from J.B. Hunt Transport, Inc. is considered confidential and for use by the intended recipient or entity only. Any unauthorized distribution of emails, attachments, or information therein is strictly prohibited.