tzdata timezone boundaries

From: Jerome Wagner <jerome(dot)wagner(at)laposte(dot)net>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: tzdata timezone boundaries
Date: 2017-07-29 10:03:35
Message-ID: CA+=V_fPBkr7d_FaGLjnN9u9yDgBKywfB=i96i9G53yvB_7W2Sw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

Is there a way to have access to the tzdata boundaries from within postgres
?

the zdump linux command gives something like

------
zdump -v /usr/share/zoneinfo/America/Los_Angeles | grep 2017

Sun Mar 12 09:59:59 2017 UTC = Sun Mar 12 01:59:59 2017 PST isdst=0
gmtoff=-28800
Sun Mar 12 10:00:00 2017 UTC = Sun Mar 12 03:00:00 2017 PDT isdst=1
gmtoff=-25200
Sun Nov 5 08:59:59 2017 UTC = Sun Nov 5 01:59:59 2017 PDT isdst=1
gmtoff=-25200
Sun Nov 5 09:00:00 2017 UTC = Sun Nov 5 01:00:00 2017 PST isdst=0
gmtoff=-28800
------

I guess that postgres have access to these datas to be able to correcly
handle timezone, but I can't find a way to surface these boundaries (except
maybe with a smart generate_series scheme (?))

nb: I asked the question on stack overflow to no avail -
https://stackoverflow.com/questions/45381924/postgresql-how-to-extract-a-list-of-past-and-known-future-offset-changes-for-a

Thanks,
Jérôme Wagner

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Farber 2017-07-29 12:13:59 number of referencing and referenced columns for foreign key disagree
Previous Message Andrew Kerber 2017-07-29 02:41:48 PGpool question