Skip to content

Instantly share code, notes, and snippets.

@Yenwod

Yenwod/postgres-translate-utc.sql

Created May 24, 2014 13:10
Show Gist options
  • Save Yenwod/2f042c0c909abd818468 to your computer and use it in GitHub Desktop.
Save Yenwod/2f042c0c909abd818468 to your computer and use it in GitHub Desktop.
Download ZIP
PostgreSQL translate UTC to another time zone in query
Raw
postgres-translate-utc.sql
-- source: http://icu.iorahealth.com/blog/2012/05/07/expressing-postgresql-timestamps-without-zones-in-local-timee
select id, route, url_id, created_at at time zone 'UTC' at time zone 'US/Eastern' from visitors order by id desc;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment