Обсуждение: Incorrect interpretation of time zone "Africa/Sao_Tome" on PG 9.6?

Поиск
Список
Период
Сортировка

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

От
Philippe Lavoie-Mongrain
Дата:
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?

От
Alvaro Herrera
Дата:
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