Re: Timestamp with Timezone - Mailing list pgsql-general

From Norberto Meijome
Subject Re: Timestamp with Timezone
Date
Msg-id 4383176D.60803@meijome.net
Whole thread Raw
In response to Timestamp with Timezone  (Matthew Terenzio <matt@jobsforge.com>)
List pgsql-general
Matthew Terenzio wrote:

> reading the docs . . . let's see if I've got it.
>
> 1. Timestamp with timezone accepts a timestamp with the additional
> timezone, converts it and stores it as GMT
> 2. It returns the value as the timestamp converted to the timezone of
> the local machine?

that's what it says, that's what it seems to do :)
you may also want to read section 9.9.3 of the 8.1 pgsql docs on how to
return the given timestamp in another TZ.

cheers,
Beto

pgsql-general by date:

Previous
From: CSN
Date:
Subject: Re: not null error in trigger on unrelated column
Next
From: Chris Kratz
Date:
Subject: Re: Rule appears not to fire on insert w/ "except"