SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

History xml file timestamp format

JSmydoDec 21 2017 — edited Dec 22 2017

I've recently upgraded to 17.3 from 3.2 and find now that I can't recover any code run in a worksheet from the History window. On closer inspection I can see that the XML history files are being created alright but contain timestamp elements in this format:

There's obviously some conversion taking place or the wrong thing is being held here. Is there any way to configure this so my files can get picked up?

Gaz in Oz

Leave the SQL Developer history files format alone.

If you want to get the "timestamp" into readable format, then you can convert the epoch timestamp into readable form using:

alter session set nls_timestamp_format = 'YYYY-MM-DD HH24:MI:SS.FF3';
SELECT to_timestamp('1970-01-01', 'yyyy-mm-dd') +
       numtodsinterval(1513762282594 / 1000, 'SECOND') readable
FROM   dual;
READABLE
--------------------------------
2017-12-20 09:31:22.594

...for example.

1 - 1

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 18 2018

Added on Dec 21 2017

#sql-developer

1 comment

217 views

SQL Developer

History xml file timestamp format

Comments

Post Details