Timezone database changes - Mailing list pgsql-hackers

From Bruce Momjian
Subject Timezone database changes
Date
Msg-id 200710090348.l993mOG15547@momjian.us
Whole thread Raw
Responses Re: Timezone database changes
Re: Timezone database changes
List pgsql-hackers
I had a thought a week ago.  If we update the time zone database for
future dates, and you have a future date/time stored, doesn't the time
change when the time zone database changes.

For example if I schedule an appointment in New Zealand for 10:00a and
we change the time zone database so that date is now daylight savings,
doesn't the time change to display as 9 or 11am?  That seems pretty bad.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://postgres.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: type money causes unrestorable dump
Next
From: Bruce Momjian
Date:
Subject: Re: [COMMITTERS] pgsql: Added the Skytools extended transaction ID module to contrib as