Skip to content

Instantly share code, notes, and snippets.

@trevvvy

trevvvy/gist:a6b2f75b1326fa8efd2f

Created July 24, 2014 21:14
Show Gist options
  • Save trevvvy/a6b2f75b1326fa8efd2f to your computer and use it in GitHub Desktop.
Save trevvvy/a6b2f75b1326fa8efd2f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
select
start_at AT TIME ZONE 'UTC' AT TIME ZONE 'America/Vancouver'
from
appointments
where
date(start_at AT TIME ZONE 'UTC' AT TIME ZONE 'America/Vancouver') = '2014-07-24';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment