On Fri, May 27, 2011 at 2:32 PM, Kevin Grittner <kevin.gritt...@wicourts.gov> wrote: > I think the key thing is that the timestamp portion of it would be > identical to our current TIMESTAMP WITH TIME ZONE -- always store it > in the value UTC zone.
Fwiw our timestamp with time zone stores seconds since the epoch. This is a quantity which is independent of timezones entirely. Excluding relativistic effects there have been the same number of time zones since that point in time regardless of where you stand relative to the sun. My question for Alvarro is whether he really wants the text label for the time zone at all, or just the offset which was used to enter it. That is, if I enter "12:00pm" with my current time zone set to GMT and later update the tzdata on the machine to start summer time on a earlier date should the data type now show "1:00pm BST" or should it still display "12:00pm +000" and leave it up to the reader to decide whether why I entered it in a weird time zone for that time of year? -- greg -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers