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

From Kevin Grittner
Subject Re: Why data of timestamptz does not store value of timezone passed to it?
Date
Msg-id 1409263788.60223.YahooMailNeo@web122305.mail.ne1.yahoo.com
Whole thread Raw
In response to Re: Why data of timestamptz does not store value of timezone passed to it?  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
> 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?

More so than CHAR(n).  It would have been beneficial to support for
the same reason.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Function to know last log write timestamp
Next
From: Josh Berkus
Date:
Subject: Re: Why data of timestamptz does not store value of timezone passed to it?