Toad World® Forums

Quick Export to Excel file and Ecxel Instance works different for timestamp datatypes


#1

Hi,

Quick Export to Excel file and Ecxel Instance works different for timestamp datatypes. To file works better from my point of view :slight_smile: See screen attached.

TDP 3.4.0.1883, Oracle 10g, Excel 2010, W7 64bit

regards,

Alex


#2

Hi,

is there any solution/reply for this?


#3

To Alex M:

Thank you for posting in Toad World. We apologize for the late response. I was unable to reproduce it using the latest beta. You can obtain the latest beta here and see if it works out okay:

http://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program/default.aspx

-Joshua Liong


#4

I reported this issue far far ago. It still ocures.

Saple query: select sysdate, to_char(sysdate, ‘yyyy-mm-ss hh24:mi:ss’) from dual

result: 4172045375, 2014-03-24 10:53:24

first column is visible as ###########… Hint from excel informs that negative or too long dates are displayed this way.