I am trying to make a cql request to a local instance of geoserver with a postgres backend Requests such as http://localhost:8090/geoserver/wfs?service=wfs&version=2.0.0&request=GetFeature&typeName=windproc:windproc_view&outputFormat=application/json&CQL_FILTER=BBOX(geom%2C-12.875%2C26.125%2C42.125%2C55.125%2C%27EPSG%3A4326%27)%20AND%20reading_time%3D2018-12-25T06%3A00%3A00Z&srsname=EPSG:4326 Work ie the date is 2018-12-25 Making a request such as http://localhost:8090/geoserver/wfs?service=wfs&version=2.0.0&request=GetFeature&typeName=windproc:windproc_view&outputFormat=application/json&CQL_FILTER=BBOX(geom%2C-12.875%2C26.125%2C42.125%2C55.125%2C%27EPSG%3A4326%27)%20AND%20reading_time%3D2018-06-25T06%3A00%3A00Z&srsname=EPSG:4326 returns nothing! A bit of digging in the logs and I can I can see that a request e date and time has been translated into a request for data from the database of using 2018-06-25 0700, since the database only has records for 0600 it does'nt find any data.
Basically geoserver is converting a date into daylight saving time format, and then making a request in the database. Q. How do I tell the geoserver , not to convert a date in cql into a daylight saving version ? I assume the issue is date format issue, I normally supply a date as something like 2018-12-25T06:00:00.000Z Thanks in advance for any help. Dave.
_______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
