Re: question about timestamp with tz

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: the6campbells <the6campbells(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: question about timestamp with tz
Date: 2009-10-22 23:26:37
Message-ID: dcc563d10910221626v1a8c385fw1caeef0934474103@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thu, Oct 22, 2009 at 2:41 PM, the6campbells <the6campbells(at)gmail(dot)com> wrote:
> Question.. is there a way that I can get Postgres to return the tz as
> supplied on the insert statement

PostgreSQL converts the timezone to GMT and stores it with no offset,
then adds an offset based on the TZ of the client requesting it back
later.

If you want to store the offset you'll have to do it yourself. Note
that offset does not necessarily = timezone...

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Craig Ringer 2009-10-23 10:59:34 Re: @@Error equivalent in Postgresql
Previous Message Tom Lane 2009-10-22 23:15:57 Re: date + interval year - why is the return type convered to a timestamp?