> As far as I know, it's not possible to get output like the following
> from the same query if the data type is timestamp with time zone:
>
> 2005-04-21 15:00:00-07
> 2005-04-21 22:00:00+00
Doesn't "at time zone" do what you need ?
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346