How to change Timezone for Postgres?

Issue

I want to know how to change the timezone to 'Brazil / East' for Postgres.

Resolution

We highly suggest leaving your Database times in UTC and modifying them at your application level. This results in your data being more ubiquitous and easier to convert when needed. Having dates in the database using a different timezone to be problematic since many libraries and functions often expect dates and times in UTC.

If you must change it, you can do so by connection to your Postgres instance with $ heroku pg:psql and running ALTER database your_database_name SET timezone ='Brazil / East' but please consider the repercussions of changing the timezone for your application.

Ask on Stack Overflow

Engage with a community of passionate experts to get the answers you need

Ask on Stack Overflow

Heroku Support

Create a support ticket and our support experts will get back to you

Contact Heroku Support
Terms of Service Privacy Cookies © 2018 Salesforce.com