Re: [GENERAL] Are we backwards on the sign of timezones?

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/