On 4 Jul 2003 at 23:22, Tom Lane wrote:
> "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.
select now(), extract(timezone_hour from now());
now | date_part
-------------------------------+-----------
2003-07-05 23:15:09.760771+12 | -12
Yep, I'd say that should return +12, not -12.
--
Dan Langille : http://www.langille.org/
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
