> 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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to