Search Postgresql Archives

Re: The contents of the pg_timezone_names view bring some surprises

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxx         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

Attachment: signature.asc
Description: PGP signature


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux