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