Timestamp with timezone question. - Mailing list pgsql-sql

From Achilleus Mantzios
Subject Timestamp with timezone question.
Date
Msg-id Pine.LNX.4.44.0502211557140.7123-100000@matrix.gatewaynet.com
Whole thread Raw
Responses Re: Timestamp with timezone question.  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-sql
AFAIK, the input for a timestamptz is converted and stored as UTC.
And outputing a timezonetz value converts the internally stored UTC
value to the current locale's timezone.

So there is not a way to actually store the original TZ itself,
whereas the timetz type clearly does that.

Consider a schema designed to store internet mail.

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 ?

-- 
-Achilleus



pgsql-sql by date:

Previous
From: pginfo
Date:
Subject: Re: pg primary key bug?
Next
From: George Weaver
Date:
Subject: Re: Working with XML.