Skip to content

Instantly share code, notes, and snippets.

@DiegoTc
Last active December 2, 2018 20:15
Show Gist options
  • Save DiegoTc/acd9b4cbdbdfa5cf13648b71ab07fd7e to your computer and use it in GitHub Desktop.
Save DiegoTc/acd9b4cbdbdfa5cf13648b71ab07fd7e to your computer and use it in GitHub Desktop.
Change time zone postgresql
Choose a timezone from:
SELECT * FROM pg_timezone_names;
And set example:
ALTER DATABASE postgres SET timezone TO 'US/Central';
SELECT pg_reload_conf();
If you need to confirm the time you can use
SELECT NOW();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment