Postgres Pro
Downloads
Home   >   mailing lists

Incorrect interpretation of time zone "Africa/Sao_Tome" on PG 9.6? - Mailing list pgsql-bugs

From Philippe Lavoie-Mongrain
Subject Incorrect interpretation of time zone "Africa/Sao_Tome" on PG 9.6?
Date
Msg-id CAN--H5meRsy_nzu2cDKTgXfr1s7ag6OOpKW=dB78RVv2irguUg@mail.gmail.com
Whole thread Raw
Responses Re: Incorrect interpretation of time zone "Africa/Sao_Tome" on PG9.6?
List pgsql-bugs
Tree view
This query:
select ('2018-07-07 00:00 + 00'::timestamptz) AT TIME ZONE 'Africa/Sao_Tome'
Returns this result:
2018-07-07 00:00:00.000000

However, according to more than one source, including this one: https://www.zeitverschiebung.net/en/timezone/africa--sao_tome, it should have +1 hour offset.

Thanks,
Phil

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #15265: The program "initdb" is needed by pg_ctl but was not found in the same directory as "pg_ctl".
Next
From: Alvaro Herrera
Date:
Subject: Re: Incorrect interpretation of time zone "Africa/Sao_Tome" on PG9.6?