timezone brasil postgresql
## Edit file
/var/lib/postgresql/data/postgresql.conf
# Update
timezone='America/Sao_Paulo'
## If you're in docker container run:
apt update
apt install nano
# Run to edit file
nano /var/lib/postgresql/data/postgresql.confpostgresql change timezone on timestamp without timezone
-- You have an issue where entries in the database are recorded in local time without the timezone
-- Postgresql assumes that these entries are in fact UTC
-- This corrects these entries by converting them to actual UTC
-- You might want to update the column (from timestamp) to a timestamptz, then perform the command below
UPDATE <table>
SET <timestamptz_field> =
(<timestamptz_field> AT TIME ZONE 'UTC') AT TIME ZONE '<correct_time_zone>';
-- e.g start_date_time before = '2021-07-29 18:15:16+00' (This is from a location at GMT+2)
-- start_date_time after = '2021-07-29 16:15:16+00' (This is the actual UTC timestamp)
UPDATE public.uut_result
SET start_date_time= (start_date_time at time zone 'utc') at time zone 'Africa/Harare'Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
