Quick Export | File | Excel File does not work with timestamp columns
Steps Taken to reproduce the problem:
create a table with a timestamp column:
CREATE TABLE my_table (
created_at TIMESTAMP,
description VARCHAR(255)
);
Insert some rows
INSERT INTO my_table (created_at, description) VALUES
(CURRENT_TIMESTAMP, 'First description'),
(CURRENT_TIMESTAMP, 'Second description'),
(CURRENT_TIMESTAMP, 'Third description'),
(CURRENT_TIMESTAMP, 'Fourth description'),
(CURRENT_TIMESTAMP, 'Fifth description');
commit;
Select the table in the Object Explorer and select View Details
R-click in Data tab and select Quick Export | File | Excel File
The values on the timestamp columns are not exported:
CREATED_AT DESCRIPTION
First description
Second description
Third description
Fourth description
Fifth description
product defect TDB-4623
WORKAROUND 1
Use Tools | Export | Export Wizard and select a format for the timestamp date
WORKAROUND 2
Quick Export | File | CSV file and open the file with excel
STATUS
Waiting for fix in a future release of Toad for DB2
