Re: The contents of the pg_timezone_names view bring some surprises - Mailing list pgsql-general

On 2021-05-18 23:31:57 -0700, Bryn Llewellyn wrote:
> Africa/Algiers     | CET    | 01:00:00   | f
> Africa/Cairo       | EET    | 02:00:00   | f
> Africa/Tripoli     | EET    | 02:00:00   | f
> Africa/Tunis       | CET    | 01:00:00   | f
> CET                | CEST   | 02:00:00   | t
> EET                | EEST   | 03:00:00   | t
> Egypt              | EET    | 02:00:00   | f
> Europe/Kaliningrad | EET    | 02:00:00   | f
> Libya              | EET    | 02:00:00   | f
>
> This tells me that when CET is used as a timezone name, it denotes an offset
> of 02:00—at least at some times of the year. And when the same text is used as
> an abbrev, it denotes an offset of 01:00.

I think you are confused by the fact that it is currently summer (well,
spring) and that some countries in the Central European Time zone
observe DST and others don't.

So "Africa/Tunis" shows up with an abbreviation of "CET" and an offset
of 01:00:00 while "Europe/Vienna" has the abbreviation "CEST" and an
offset of 02:00:00. Two months ago Vienna would also had the
abbreviation "CET" and an offset of 01:00:00.
The time zone "CET" probably reflects what most countries in that zone
do, so it is currently also in DST.

Same for Eastern European Time.

        hp

--
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"