Re: [GENERAL] Are we backwards on the sign of timezones? - Mailing list pgsql-hackers

"Dan Langille" <dan@langille.org> 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