Re: [GENERAL] Are we backwards on the sign of timezones?

"Dan Langille"  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