The default timezone is currently set to UTC. How to replace that default value? I am using PostgreSQL running on top of Amazon RDS


ALTER DATABASE <db_name> SET TimeZone = 'UTC'; But you shouldn't do that. Using UTC for database is safest thing possible.

  • it is the only solution if all the users are on the same single timezone – Abel Melquiades Callejo May 17 '18 at 5:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.