Re: Why data of timestamptz does not store value of timezone passed to it? - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Why data of timestamptz does not store value of timezone passed to it?
Date
Msg-id 20140828213333.GC7705@eldon.alvh.no-ip.org
Whole thread Raw
In response to Re: Why data of timestamptz does not store value of timezone passed to it?  (Kevin Grittner <kgrittn@ymail.com>)
Responses Re: Why data of timestamptz does not store value of timezone passed to it?
List pgsql-hackers
Kevin Grittner wrote:

> But the standard doesn't say anything about storing a time zone
> *name* or *abbreviation* -- it requires that it be stored as UTC
> with the *offset* (in hours and minutes).  That makes it pretty
> close to what we have -- it's all about a difference in
> presentation.  And as far as I can see it completely dodges the
> kinds of problems you're talking about.

Yeah, it does, but is it useful?

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Why data of timestamptz does not store value of timezone passed to it?
Next
From: Thomas Munro
Date:
Subject: Multithreaded SIGPIPE race in libpq on Solaris