Re: Why data of timestamptz does not store value of timezone passed to it?

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Why data of timestamptz does not store value of timezone passed to it?
Дата
Msg-id 1409263788.60223.YahooMailNeo@web122305.mail.ne1.yahoo.com
обсуждение исходный текст
Ответ на Re: Why data of timestamptz does not store value of timezone passed to it?  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Function to know last log write timestamp
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Why data of timestamptz does not store value of timezone passed to it?