Postgres Pro
Downloads
Home   >   mailing lists

Re: Timestamp vs timestamptz - Mailing list pgsql-general

From Florian Weimer
Subject Re: Timestamp vs timestamptz
Date
Msg-id 82fyh463z8.fsf@mid.bfk.de
Whole thread Raw
In response to Re: Timestamp vs timestamptz  (Agent M <agentm@themactionfaction.com>)
Responses Re: Timestamp vs timestamptz
List pgsql-general
Tree view 
* 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@bfk.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

pgsql-general by date:

Previous
From: Volkan YAZICI
Date:
Subject: Re: stored function - array parameter - how many element in array ?
Next
From: "surabhi.ahuja"
Date:
Subject: Re: cant connect to the database, even after doing start