"Dan Langille" <[EMAIL PROTECTED]> writes: > Now that my NZ server is up and running: > template1=# select now(); > 2003-07-05 12:47:15.444535+12
> That doesn't look backwards to me.
Try EXTRACT(timezone_hour from now());
The timestamp I/O routines are using what I think is the correct sign.
EXTRACT() is at variance. So is SET TIMEZONE with a numeric offset.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
