6

In a PostGIS view i have a field of data type "timestamp with time zone". In GeoServer this field is show with datatype "Timestamp" enter image description here

My problem is that i want the Timestamp to be show in my application exactly as it is in my Database as UTM. +00.

What i get back from GeoServer via WFS request is:

2010-08-20T16:56:15.095-04:00

What is stored in the PostGIS database is:

2010-08-20 20:56:15.095+00

How do i tell GeoServer not to convert the time so that i see the time exactly how it is in the database as UTM? Is it on Apache, System Time, GeoServer config?

Running GeoServer on latest stable Suse linux Ent.

6

The only way I can think of is to change the default timezone on your server so that it is UTM+00. When the postgres jdbc driver gets the date from the server it will parse it into a Date object, which will by default display it in the default timezone. And there is no way with GeoServer wfs to supply a custom format for date output in GML.

You can try setting the timezone with the jvm system property: -Duser.timezone=GMT.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.