Re: Timestamp with timezone question.

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: Timestamp with timezone question.
Дата
Msg-id 20050222065946.GA5861@wolff.to
обсуждение исходный текст
Ответ на Timestamp with timezone question.  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
Ответы Re: Timestamp with timezone question.  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
Список pgsql-sql
On Mon, Feb 21, 2005 at 16:16:04 +0200, Achilleus Mantzios <achill@matrix.gatewaynet.com> wrote:
> 
> Since pgsql always converts a timestamptz to UTC, we have lost
> the information of the Sender's local timezone.
> 
> Should i go with a separete date and timetz ?

Someone else gave you a recommended solution.

However there was a discussion on the order of 6 months ago about changing
the timestamptz type to keep this information. Nothing will be changing
in the near future, but you may (or may not) find the discussion useful.


В списке pgsql-sql по дате отправления:

Предыдущее
От: pginfo
Дата:
Сообщение: Re: pg primary key bug?
Следующее
От: Achilleus Mantzios
Дата:
Сообщение: Re: Timestamp with timezone question.