Skip to content

Instantly share code, notes, and snippets.

@krisrice
Created February 22, 2023 21:23
Show Gist options
  • Save krisrice/aff14a51aa6acc34536c31929ff608be to your computer and use it in GitHub Desktop.
Save krisrice/aff14a51aa6acc34536c31929ff608be to your computer and use it in GitHub Desktop.
/*
*** 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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment