Toad World® Forums

Ctrl+c not always correct copy timestamp col


#1

Hi!

Try this :

1.CREATE TABLE TEST_copy (col1 timestamp);
2.insert into test_copy values(to_timestamp(sysdate));
commit;
F3

Then try to copy value from column using ctrl+c not right clicking, and paste into sqlEditor. Value for timestamp sometimes is trimmed to same date, or sometimes some values at the end of value are missing.
Try cliking on cell and copy/paste, an few times the same scenario.

Regards Piter


#2

Hey there Piter,

I have reproduced your issue… there is something fishy!!
If the entire row is selected the Ctrl + C trims
If the content only is selected the Ctrl + C works correctly
(The right click copy option fails in the same circumstance as well)

I’ll verify with the developers that this is not correct (seems wrong to me) and raise a CR accordingly!!

Thanks No1 dad

Jaime
this will fail.jpeg


#3

Hey there Piter,

I have reproduced your issue… there is something fishy!!
If the entire row is selected the Ctrl + C trims
If the content only is selected the Ctrl + C works correctly
(The right click copy option fails in the same circumstance as well)

I’ll verify with the developers that this is not correct (seems wrong to me) and raise a CR accordingly!!

Thanks No1 dad

Jaime
this will work.jpeg