Re: Timestamp with timezone question.

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Timestamp with timezone question.
Date: 2005-02-22 06:59:46
Message-ID: 20050222065946.GA5861@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Mon, Feb 21, 2005 at 16:16:04 +0200,
Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Achilleus Mantzios 2005-02-22 08:24:11 Re: Timestamp with timezone question.
Previous Message pginfo 2005-02-22 05:25:37 Re: pg primary key bug?