Re: timestamp <-> ctime conversion question... - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: timestamp <-> ctime conversion question...
Date
Msg-id 20051213195511.GN5531@merkur.hilbert.loc
Whole thread Raw
In response to Re: timestamp <-> ctime conversion question...  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
On Tue, Dec 13, 2005 at 12:34:19PM -0700, Michael Fuhr wrote:

> > *Display* of timestamptz values at arbitrary time zones is
> > already possible using the "at time zone" syntax.
>
> But the result is a timestamp without time zone and thus doesn't
> display the target time zone.  In other words, you can display a
> timestamptz *at* another time zone but not *with* another time zone.
Ah, OK, there's a subtle difference, true.

However, if in my code I am able to say "at time zone ..." I
*already* know the time zone. Can't I then just *add* it to
the value I am getting back from the database ?

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: timestamp <-> ctime conversion question...
Next
From: David Rysdam
Date:
Subject: "incomplete startup packet" on SGI