Thread: postgresql support new time zone TRT
Hello,
Does PostgreSQL support the new time zone TRT (the new time zone for Turkey)?
Thanks!
Best Regards
Audrey
On Tue, Oct 25, 2016 at 7:45 PM, Ziyun Audrey Wang <ziyun.wang@ericsson.com> wrote: > Does PostgreSQL support the new time zone TRT (the new time zone for > Turkey)? This would probably have had a better chance of being answered on pgsql-general than here btw. As it happens the answer is that the next point release will have the updated Turkish time zone rules. The change was made on very short notice and I believe was actually announced and implemented all after the last point release so there was no chance for it to have been updated. Politicians it appears have such high regard for computer programmers that we're expected to see the future. -- greg
On Tue, Oct 25, 2016 at 7:45 PM, Ziyun Audrey Wang <ziyun.wang@ericsson.com> wrote: > Does PostgreSQL support the new time zone TRT (the new time zone for > Turkey)? This would probably have had a better chance of being answered on pgsql-general than here btw. As it happens the answer is that the next point release will have the updated Turkish time zone rules. The change was made on very short notice and I believe was actually announced and implemented all after the last point release so there was no chance for it to have been updated. Politicians it appears have such high regard for computer programmers that we're expected to see the future. -- greg
Ziyun Audrey Wang wrote: > Does PostgreSQL support the new time zone TRT (the new time zone for Turkey)? Yes, if you install the latest updates. https://www.postgresql.org/docs/current/static/release-9-6-1.html says: > Update time zone data files to tzdata release 2016h for DST law changes in Palestine and Turkey, > plus historical corrections for Turkey and some regions of Russia. Switch to > numeric abbreviations for some time zones in Antarctica, the former Soviet Union, and Sri Lanka. Yours, Laurenz Albe
Albe Laurenz <laurenz.albe@wien.gv.at> writes: > Ziyun Audrey Wang wrote: >> Does PostgreSQL support the new time zone TRT (the new time zone for Turkey)? > Yes, if you install the latest updates. Note that per http://mm.icann.org/pipermail/tz-announce/2016-September/000041.html the IANA TZ folk have not chosen to instantiate "TRT" as a time zone abbreviation: Turkey switched from EET/EEST (+02/+03) to permanent +03, effective 2016-09-07. (Thanks to Burak AYDIN.) Use "+03" rather than an invented abbreviation for the new time. This is in line with their new policy of not inventing abbreviations that don't have any real-world currency. If you have evidence that "TRT" is actually in use in Turkey, please send it to the TZ list (not here). regards, tom lane
Ziyun Audrey Wang wrote: > Does PostgreSQL support the new time zone TRT (the new time zone for Turkey)? Yes, if you install the latest updates. https://www.postgresql.org/docs/current/static/release-9-6-1.html says: > Update time zone data files to tzdata release 2016h for DST law changes in Palestine and Turkey, > plus historical corrections for Turkey and some regions of Russia. Switch to > numeric abbreviations for some time zones in Antarctica, the former Soviet Union, and Sri Lanka. Yours, Laurenz Albe
Albe Laurenz <laurenz.albe@wien.gv.at> writes: > Ziyun Audrey Wang wrote: >> Does PostgreSQL support the new time zone TRT (the new time zone for Turkey)? > Yes, if you install the latest updates. Note that per http://mm.icann.org/pipermail/tz-announce/2016-September/000041.html the IANA TZ folk have not chosen to instantiate "TRT" as a time zone abbreviation: Turkey switched from EET/EEST (+02/+03) to permanent +03, effective 2016-09-07. (Thanks to Burak AYDIN.) Use "+03" rather than an invented abbreviation for the new time. This is in line with their new policy of not inventing abbreviations that don't have any real-world currency. If you have evidence that "TRT" is actually in use in Turkey, please send it to the TZ list (not here). regards, tom lane