Re: Are we backwards on the sign of timezones?

From: "Dan Langille" <dan(at)langille(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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 00:58:17
Message-ID: 3F05EA69.20820.6F7AEAFF@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On 3 Jul 2003 at 13:18, Tom Lane wrote:

> Comments?

Now that my NZ server is up and running:

template1=# select now();
now
-------------------------------
2003-07-05 12:47:15.444535+12

That doesn't look backwards to me. Perhaps I don't understand the
problem. After rereading your original post:

Local time is equal to UTC (Coordinated Universal Time) plus
the time zone displacement,

In the above, the local time is 2003-07-05 12:47:15.444535. UTC
would be 2003-07-05 00:47:15.444535. To which we add +12 hours to
get local time. That appears to be consistent with the SQL99 spec.
--
Dan Langille : http://www.langille.org/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message nolan 2003-07-05 00:59:16 Tables larger than 1GB
Previous Message Bjoern Metzdorf 2003-07-04 22:24:18 Re: PostgreSQL vs. MySQL

Browse pgsql-hackers by date

  From Date Subject
Next Message MIka Santos 2003-07-05 01:56:10 Need help for our thesis.
Previous Message Stephan Szabo 2003-07-04 23:34:31 Re: '_' < '5' -- different answer on 7.2 and 7.3