[Geoserver-users] Change date format

Hello everyone,

I'm just wondering if it's possible to change the format that Geoserver uses
to parse the date from a database (in my case postgresql with postgis
extension).

From browsing the mailinglist I found out that it uses this method to parse

dates:
SimpleDateFormat format = (SimpleDateFormat)DateFormat.getInstance();
So is it possbile to tell Geoserver a certain format like:
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"), which is
also used in postgresql?

I'm trying to retrieve data from the backend posgresql database via
Geoserver's WFS service within a certain time period. Therefore Geoserver
has to compare my inputed timestamps with the ones in the database. When
Geoserver reads then the dates from postgresql, I get the following
execption:
java.text.ParseException: Unparseable date: "2001-02-11T20:03:00Z"
  at java.text.DateFormat.parse(DateFormat.java:337)

I need to change the format in Geoserver, because - as I understand - I
can't change the format that postgresql uses to save the dates.

Thanks in advance!

Best regards, Thalles
--
View this message in context: http://www.nabble.com/Change-date-format-tp23922541p23922541.html
Sent from the GeoServer - User mailing list archive at Nabble.com.