Re: Timestamp vs timestamptz

From: Florian Weimer <fweimer(at)bfk(dot)de>
To: Agent M <agentm(at)themactionfaction(dot)com>
Cc: Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Timestamp vs timestamptz
Date: 2006-07-14 07:27:23
Message-ID: 82fyh463z8.fsf@mid.bfk.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* Agent M.:

> timestamp with time zone does not record the timezone you inserted it
> with- it simply stores the GMT version and converts to whatever
> timezone you like on demand.

Are you sure? This behavior is not documented, and I can't reproduce
it with PostgresQL 8.1.4.

--
Florian Weimer <fweimer(at)bfk(dot)de>
BFK edv-consulting GmbH http://www.bfk.de/
Durlacher Allee 47 tel: +49-721-96201-1
D-76131 Karlsruhe fax: +49-721-96201-99

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message surabhi.ahuja 2006-07-14 07:48:55 Re: cant connect to the database, even after doing start
Previous Message Volkan YAZICI 2006-07-14 06:28:58 Re: stored function - array parameter - how many element in array ?