trace_to_timestamp.sql

/*
*** 2023-02-22 05:03:44.482 (M18VE(3))
*** SESSION ID:(3405.27040) 2023-02-22 05:03:44.482
*** CLIENT ID:() 2023-02-22 05:03:44.482
*** SERVICE NAME:(sm18ve) 2023-02-22 05:03:44.482
*** MODULE NAME:(JDBC Thin Client) 2023-02-22 05:03:44.482
*** ACTION NAME:() 2023-02-22 05:03:44.482
*** CLIENT DRIVER:() 2023-02-22 05:03:44.482
*** CONTAINER ID:(3) 2023-02-22 05:03:44.482
 
=====================
PARSING IN CURSOR #139819303749800 len=82 dep=1 uid=0 oct=3 lid=0 tim=3017709829740 hv=3873422482 ad='11f0da898' sqlid='0k8522rmdzg4k'

*/
with params as (
        select  (cast (timestamp '2023-02-22 05:03:44.482' at time zone 'UTC' as date) - date '1970-01-01') * 86400 as  startT
        ,      (3017709829740 * 0.000001) offsetT
        from dual
    )
    select TO_TIMESTAMP('1970-01-01 00:00:00.000', 'YYYY-MM-DD hh24:mi:SS.FF3')
                + numtodsinterval(startT+offsetT/1000, 'SECOND') parsing_time
 from params;