From: Laszlo Nagy <gandalf@shopzeus.com>
To: Steve Crawford <scrawford@pinpointresearch.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: [ADMIN] Messed up time zones
Date: Fri, 03 Aug 2012 20:37:45 +0200
Message-ID: <501C1A79.8080707@shopzeus.com> (raw)
In-Reply-To: <501C17B1.6020604@pinpointresearch.com>
References: <501B8C6F.6040100@shopzeus.com>
<501BAA84.9010306@shopzeus.com>
<501BAE33.4090102@shopzeus.com>
<16399.1344003584@sss.pgh.pa.us>
<501BED07.5070603@shopzeus.com>
<501BFA4F.5010709@pinpointresearch.com>
<501C0884.1040106@shopzeus.com>
<501C17B1.6020604@pinpointresearch.com>
> So you took two distinct points in time, threw away some critical
> information, and are surprised why they are now equal?
Well, I did not want to throw away any information. The actual
representation could be something like:
"2012-11-04 01:30:00-08 in Europe/Budapest, Winter time"
and
"2012-11-04 01:30:00-08 in Europe/Budapest, Summer time".
It would be unambiguous, everybody would know the time zone, the UTC
offset and the time value, and conversion back to UTC would be
unambiguous too.
I presumed that the representation is like that. But I was wrong. I have
checked other programming languages. As it turns out, nobody wants to
change the representation just because there can be an ambiguous hour in
every year. Now I think that most systems treat ambiguous time stamps as
if they were in standard time. And who am I to go against the main flow?
I'm sorry, I admit that the problem was in my head.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: gandalf@shopzeus.com, scrawford@pinpointresearch.com
Subject: Re: [ADMIN] Messed up time zones
In-Reply-To: <501C1A79.8080707@shopzeus.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox