[Geoserver-users] GeoServer converting timestamp with time zone

Diego_M · January 19, 2013, 7:55am

I installed GeoServer (at tomcat) on two machines, windows (GeoServer 2.1.2)
and ubuntu (GeoServer 2.2.3).

on windows, the timestamp of my data is exactly as it is in my database, but
on ubuntu, it displays [-3 hours] of database timestamp
e.g:

What i get back from GeoServer via WFS request is:
2013-01-18T22:10:23Z
What is stored in the PostGIS database is:
2013-01-19 01:10:23

How can I fix this issue? I need them to be the same.

--
View this message in context: http://osgeo-org.1560.n6.nabble.com/GeoServer-converting-timestamp-with-time-zone-tp5028434.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

Shadin · January 19, 2013, 10:54am

you can fix this bt adding a default timezone.

For Tomcat it's the file [/etc/defaults/tomcat6]

The default CATALINA_OPTS might look like this:

JAVA_OPTS="-Djava.awt.headless=true -Xmx128M -server"

you should add:

JAVA_OPTS="-Djava.awt.headless=true -Xmx128M -server -Duser.timezone=GMT"
or whatever timezone you want.