Re: Timestamp with timezone question. - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: Timestamp with timezone question.
Date
Msg-id 20050222065946.GA5861@wolff.to
Whole thread Raw
In response to Timestamp with timezone question.  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
Responses Re: Timestamp with timezone question.  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
List 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 by date:

Previous
From: pginfo
Date:
Subject: Re: pg primary key bug?
Next
From: Achilleus Mantzios
Date:
Subject: Re: Timestamp with timezone question.