Skip to content

Instantly share code, notes, and snippets.

@mrdoornbos

mrdoornbos/update_accounts_sql.sql

Created May 1, 2017 11:16
Show Gist options
  • Save mrdoornbos/47ab321a96f7b28c35b37ff72d81c90b to your computer and use it in GitHub Desktop.
Save mrdoornbos/47ab321a96f7b28c35b37ff72d81c90b to your computer and use it in GitHub Desktop.
Download ZIP
Update SH Database accounts to fix timezones
Raw
update_accounts_sql.sql
select * from Locations where Account = '73300'
update Locations set timezone = 'Alaska' where Account = '73300'
select * from Locations where Account = '73300'
select * from Locations where Account = '73230'
update Locations set timezone = 'Hawaii' where Account = '73230'
select * from Locations where Account = '73230'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment