Change PostgreSQL timezone

Set timezone on database level

Get bugscoder’s stories in your inbox
Join Medium for free to get updates from this writer.
Remember me for faster sign in
ALTER DATABASE <your_database_name> SET timezone = 'UTC';

Set timezone on global level

-- This modifies postgresql.auto.conf
ALTER SYSTEM SET timezone = 'UTC';

-- Reload configuration (no restart needed)
SELECT pg_reload_conf();

-- Verify it worked
SHOW timezone;