> 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 majordomo@xxxxxxxxxxxxxx
