Incorrect interpretation of time zone "Africa/Sao_Tome" on PG 9.6?

From: Philippe Lavoie-Mongrain <philippe(dot)lavoie-mongrain(at)breather(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Incorrect interpretation of time zone "Africa/Sao_Tome" on PG 9.6?
Date: 2018-07-06 22:23:44
Message-ID: CAN--H5meRsy_nzu2cDKTgXfr1s7ag6OOpKW=dB78RVv2irguUg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2018-07-06 22:36:24 Re: Incorrect interpretation of time zone "Africa/Sao_Tome" on PG 9.6?
Previous Message Tom Lane 2018-07-06 20:02:30 Re: BUG #15265: The program "initdb" is needed by pg_ctl but was not found in the same directory as "pg_ctl".