ToQoz/redshift-unix-timestamp-to-datetime-example.sql

Created June 30, 2017 06:29

Star 0 You must be signed in to star a gist
Fork 0 You must be signed in to fork a gist

Download ZIP

Raw

redshift-unix-timestamp-to-datetime-example.sql

select timestamp 'epoch' + CAST(ts AS BIGINT)/1000 * interval '1 second' from (select 1498783941705 AS ts);

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment