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/
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 |
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 |