Re: Are we backwards on the sign of timezones?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dan Langille" <dan(at)langille(dot)org>
Cc: pgsql-hackers(at)postgreSQL(dot)org, pgsql-general(at)postgreSQL(dot)org
Subject: Re: Are we backwards on the sign of timezones?
Date: 2003-07-05 03:22:11
Message-ID: 2172.1057375331@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

"Dan Langille" <dan(at)langille(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Björklund 2003-07-05 05:17:48 Re: Datatypes and performance
Previous Message Alvaro Herrera 2003-07-05 03:12:59 Re: Datatypes and performance

Browse pgsql-hackers by date

  From Date Subject
Next Message Hans-Jürgen Schönig 2003-07-05 05:48:53 PostgreSQL 7.3.3 and Intel C compiler
Previous Message Joe Conway 2003-07-05 03:00:17 Re: Proof-of-concept for initdb-time shared_buffers selection