timestamp with time zone, retrieving input offset/timezone

From: "Der Tung" <dertung(at)gmx(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Subject: timestamp with time zone, retrieving input offset/timezone
Date: 2009-08-04 11:09:26
Message-ID: 000001ca14f4$097133f0$1c539bd0$@de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

If it saves the timezone/offset, how can I access it?

Regards,

Der Tung

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Glyn Astill 2009-08-04 11:38:36 Re:
Previous Message sweta 2009-08-04 10:03:36 Re: