jeromecos
HOBBY
9 months ago
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';
0 Replies
9 months ago
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
9 months ago
i'm sure it is one way or another, unfortunately i won't be able to assist with implementing poor practices.