| From: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: timestamp <-> ctime conversion question... |
| Date: | 2005-12-13 19:55:11 |
| Message-ID: | 20051213195511.GN5531@merkur.hilbert.loc |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | kbforge | 2005-12-13 20:07:03 | New release: - kbforge 1.20 Free desktop search application with PGSQL database option |
| Previous Message | Michael Fuhr | 2005-12-13 19:34:19 | Re: timestamp <-> ctime conversion question... |