Cannot change Postgres TImezone
Hello, I couldn't change the database timezone, I have tried the following commands:
ALTER DATABASE postgres SET timezone TO 'Asia/Kuala_Lumpur';
ALTER ROLE postgres SET timezone TO 'Asia/Kuala_Lumpur';5 Replies
Project ID:
b01880bc-a5fa-4f41-b977-800d4b3367efb01880bc-a5fa-4f41-b977-800d4b3367ef
you would not want to change the timezone, you should keep it in UTC as it a universal standard to do timestamps in UTC and convert to a local timezone for display purposes
We are building an internal software and doesn't need to store it in UTC format
Is it possible to change the database timezone?
i'm sure it is one way or another, unfortunately i won't be able to assist with implementing poor practices.