Re: Timezone database changes

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Trevor Talbot" <quension(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org, "Magne =?iso-8859-1?q?M=E6hre?=" <Magne(dot)Mahre(at)sun(dot)com>
Subject: Re: Timezone database changes
Date: 2007-10-10 13:55:03
Message-ID: 200710101555.05054.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Am Mittwoch, 10. Oktober 2007 schrieb Tom Lane:
> I'm not sure that I think this sort of rigid thinking works very well in
> the wonderland that is date/time behavior.  When the rules of the game
> (ie, DST laws) are changing underneath you, who is to say exactly what
> "reading out as A" means?  Arguably, TIMESTAMP WITH TIME ZONE does the
> right thing now, and would cease to do the right thing if we changed
> it as I think you intend.

If we make an appointment at 12-November-2007 at 10:00 CET (winter time) and
next week those in charge decide to postpone the change to winter time from
28-October-2007 to 25-November-2007, what becomes of the appointment? Do we
still meet when the hands point to "10", or when?

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Aidan Van Dyk 2007-10-10 14:05:30 Re: Timezone database changes
Previous Message Tom Lane 2007-10-10 13:46:56 Re: Locale + encoding combinations