Cannot change Postgres TImezone
jer-tan
HOBBYOP

a year 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';

5 Replies

jer-tan
HOBBYOP

a year ago

b01880bc-a5fa-4f41-b977-800d4b3367ef

brody
EMPLOYEE

a year 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

jer-tan
HOBBYOP

a year ago

We are building an internal software and doesn't need to store it in UTC format

jer-tan
HOBBYOP

a year ago

Is it possible to change the database timezone?

brody
EMPLOYEE

a year ago

i'm sure it is one way or another, unfortunately i won't be able to assist with implementing poor practices.

Loading...