| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Tatsuo Ishii" <ishii(at)sraoss(dot)co(dot)jp> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: timestamp with time zone |
| Date: | 2007-12-13 16:57:59 |
| Message-ID: | dcc563d10712130857j633aa80fvcc71a86bbce50133@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Dec 12, 2007 11:10 PM, Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp> wrote:
> Hi,
>
> Can someone enlighten me?
>
> I know that I can insert date/time data along with time zone info into
> the timestamp with time zone data type. My question is, can I extract
> the *original* time zone info afterward? I seems impossible.
Yep, that's correct. Basically, when you store a timestamp with
timezone, postgresql converts it to UTC and stores that. when you get
it back, it converts it to the timezone of the client currently
connected. If you want to store the timezone you'll have to create
another field to hold that.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Erik Jones | 2007-12-13 16:58:20 | Re: autovacuum log? |
| Previous Message | Scott Marlowe | 2007-12-13 16:55:52 | Re: index organized tables use case |