Skip to content

Instantly share code, notes, and snippets.

@ToQoz

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

Created June 30, 2017 06:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ToQoz/563845be0bfbc1c4e999f5838b59d61b to your computer and use it in GitHub Desktop.
Save ToQoz/563845be0bfbc1c4e999f5838b59d61b to your computer and use it in GitHub Desktop.
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