Hi,
I'm doing some tests on postgis and I have some timezone issues.
I live in Italy, some I'm +2 compared to Greenwich.
Now, with the following data in the db:
dt | timetest | datetest
-------------------------+--------------+------------
2007-07-02 12:06:37.671 | 15:48:50.531 | 2007-07-04
and the xml rendering is:
<topp:dt>2007-07-02T12:06:37.671+02:00</topp:dt>
<topp:timetest>15:48:50</topp:timetest>
<topp:datetest>2007-07-03+00:00</topp:datetest>
dt and timetest are correct, datetest is... humm...
well, suprising, but not fully incorrect.
I mean, 2007-07-04 00:00 in timezone +2 is
in fact 2007-07-03 22:00 in timezone +0...
but this should not really happen.
Is there any reason why you forced GMT timezone for
dates? I think 2007-07-04+02:00 or simply 2007-07-04
would be both more correct.
Cheers
Andrea
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
