1 Reply Latest reply on Dec 22, 2017 5:22 AM by Gaz in Oz

    History xml file timestamp format

    JSmydo
    JSmydo Dec 21, 2017 11:04 AM

      Hi

       

      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:

       

      <timestamp><![CDATA[1513762282594]]</timestamp>

       

      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?

        • 1. Re: History xml file timestamp format
          Gaz in Oz
          Gaz in Oz Dec 22, 2017 5:22 AM (in response to JSmydo)

          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.