Skip to content

Instantly share code, notes, and snippets.

@DiegoTc

DiegoTc/information.txt

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.
Download ZIP
Change time zone postgresql
Raw
information.txt
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