Re: timestamp with time zone, retrieving input offset/timezone - Mailing list pgsql-general

From Scott Marlowe
Subject Re: timestamp with time zone, retrieving input offset/timezone
Date
Msg-id dcc563d10908041224jf282d0bjf09a3717b2f936ba@mail.gmail.com
Whole thread Raw
In response to timestamp with time zone, retrieving input offset/timezone  ("Der Tung" <dertung@gmx.de>)
List pgsql-general
On Tue, Aug 4, 2009 at 5:09 AM, Der Tung<dertung@gmx.de> wrote:
> Hello there,
>
> We are creating an Application that needs to handle timestamps in different
> timezones in particular:
>
> Input and output in timezone of the User is no problem with
>
> Set Time Zone and At Time Zone
>
> But know I have two Users A and B in different  timezones.
>
> When A saves a timestamp I want B to:
>
> -          Get the timestamp displayed in his timezone
>
> -          Get the timestamp displayed in the timezone a originally saved it
> in
>
>
>
> Does the type “timestamp with time zone” contain the original timezone or at
> least the offset to UTC it was saved in, or does it just save the UTC time?

Just UTC time.
If you want the offset saved, you'll have to do that yourself.

pgsql-general by date:

Previous
From: Guy Rouillier
Date:
Subject: Re: Does derby have an embedded Mode like Derby ?
Next
From: "Bayless Kirtley"
Date:
Subject: Re: Does derby have an embedded Mode like Derby ?