Skip to content

Instantly share code, notes, and snippets.

/gist:a61145fbbf519df70940

Created November 13, 2015 07:33
Show Gist options
  • Save anonymous/a61145fbbf519df70940 to your computer and use it in GitHub Desktop.
Save anonymous/a61145fbbf519df70940 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
select
top 100
log_date,
access_seconds,
CAST(DATE '1970-01-01' + ((access_seconds+32400) / 86400) AS TIMESTAMP(6))
+ (((access_seconds+32400) MOD 86400) * INTERVAL '00:00:01.000000' HOUR TO SECOND) as TM
from vdb.csc_access_log_10_2015111;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment