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/
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
