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

On 2018-Jul-06, Philippe Lavoie-Mongrain wrote:

> 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.

Apparently, Evaristo do Espirito Santo Carvalho decided to sign on
December 28th that the country would change timezone on January 1st ...
http://www.mnec.gov.st/index.php/publicacoes/documentos/file/90-decreto-lei-n-25-2017
(link found on IANA's tzdata sources)

This is updated as of 9.6.7, so if you're on an older release, you need
to upgrade. Unless your install uses system timezone data, in which
case you need to update your OS's tzdata package.

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services