alfonsodev/postgres.timezones.md

Last active August 29, 2015 14:18

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/alfonsodev/a6242ba26af71893ba41.js"></script>
Save alfonsodev/a6242ba26af71893ba41 to your computer and use it in GitHub Desktop.

Postgreesql timezones

Raw

By default postgres should be in UTC , show timezone; if it isn't change configuration timezone = 'UTC' in postgresq.conf

Store dates always in UTC, no mather user timezone, use AT TIME ZONE '' to convert it your query.

To know a list of valid values select * from pg_timezone_names;

to experiment : set timezone='Europe/Berlin' ; SELECT NOW(); SELECT NOW() AT TIME ZONE 'Europe/Berlin' SELECT NOW() AT TIME ZONE 'UTC'

Select an option