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