Skip to content

Instantly share code, notes, and snippets.

@ToQoz

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

Created June 30, 2017 06:29
Star
Embed
What would you like to do?
Learn more about clone URLs
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