Re: Timestamp with Timezone

From: Norberto Meijome <sys(at)meijome(dot)net>
To: Matthew Terenzio <matt(at)jobsforge(dot)com>
Cc: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Timestamp with Timezone
Date: 2005-11-22 13:04:45
Message-ID: 4383176D.60803@meijome.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Kratz 2005-11-22 13:12:46 Re: Rule appears not to fire on insert w/ "except"
Previous Message CSN 2005-11-22 08:43:48 Re: not null error in trigger on unrelated column