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

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

From

Philippe Lavoie-Mongrain

Date:

07 July 2018, 04:23:44

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

Re: Incorrect interpretation of time zone "Africa/Sao_Tome" on PG9.6?

From

Alvaro Herrera

Date:

07 July 2018, 04:36:24

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