If you don't specify a time zone in the filter then it is taken to be in the time zone the server is running, so either add the Z (UTC) marker in the query or add the -Duser.timezone=GMT flag to your java opts to set the server time zone to UTC/GMT
Ian On Sat, 7 Oct 2023 at 07:58, Dave Potts <mrdapo...@gmail.com> wrote: > As a follow up to my last email, this is a part of the log, if you trace > through the log, you can see geoserver received the correct time parsed it > and then turned in to a query string. Its at this point were the date > format conversion seems to happen. > > ie > CQL_FILTER=BBOX(geom%2C-12.875%2C26.125%2C42.125%2C55.125%2C%27EPSG%3A4326%27)%20AND%20reading_time%3D2018-05-27T12%3A00%3A00Z&srsname=EPSG:4326 > with /** > > becomes > To gt2: Query: > feature type: windproc_view > filter: [[ geom bbox ReferencedEnvelope[-12.875 : 42.125, 26.125 : > 55.125] DefaultGeographicCRS[EPSG:WGS 84] AXIS["Geodetic longitude", EAST] > AXIS["Geodetic latitude", NORTH] ] AND [ reading_time = Sun May 27 13:00:00 > BST 2018 ]] > > database table is > Column | Type | Collation | Nullable | > Default > > --------------+-----------------------------+-----------+----------+--------- > id | integer | | | > geom | geometry(Point,4326) | | | > lon | real | | | > lat | real | | | > uwnd | real | | | > vwnd | real | | | > angle | real | | | > speed | real | | | > reading_time | timestamp without time zone | | | > > ------------------------------------------------------------------------Log]----------------------------------------- > 07 Oct 07:48:46 DEBUG [geoserver.security] - Request matched by universal > pattern '/**' > 07 Oct 07:48:46 DEBUG [geoserver.security] - Matched Path: /wfs, > QueryString: > 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-05-27T12%3A00%3A00Z&srsname=EPSG:4326 > with /** > 07 Oct 07:48:46 TRACE [ows.OWSHandlerMapping] - Mapped to > HandlerExecutionChain with [org.geoserver.ows.Dispatcher@33210647] and 2 > interceptors > 07 Oct 07:48:46 INFO [geoserver.wfs] - > Request: getServiceInfo > 07 Oct 07:48:46 TRACE [geoserver.platform] - Found Property override: > 'org.geoserver.service.disabled' to be unset > 07 Oct 07:48:46 TRACE [geoserver.platform] - Found Java environment > variable : 'org.geoserver.service.disabled' to be unset > 07 Oct 07:48:46 TRACE [geoserver.platform] - Found Servlet context > parameter : 'org.geoserver.service.disabled' to be unset > 07 Oct 07:48:46 TRACE [geoserver.platform] - Found System environment > variable : 'org.geoserver.service.disabled' to be unset > 07 Oct 07:48:46 TRACE [geoserver.platform] - Found Property override: > 'org.geoserver.service.disabled' to be unset > 07 Oct 07:48:46 TRACE [geoserver.platform] - Found Java environment > variable : 'org.geoserver.service.disabled' to be unset > 07 Oct 07:48:46 TRACE [geoserver.platform] - Found Servlet context > parameter : 'org.geoserver.service.disabled' to be unset > 07 Oct 07:48:46 TRACE [geoserver.platform] - Found System environment > variable : 'org.geoserver.service.disabled' to be unset > 07 Oct 07:48:46 TRACE [geoserver.platform] - Found Property override: > 'org.geoserver.service.disabled' to be unset > 07 Oct 07:48:46 TRACE [geoserver.platform] - Found Java environment > variable : 'org.geoserver.service.disabled' to be unset > 07 Oct 07:48:46 TRACE [geoserver.platform] - Found Servlet context > parameter : 'org.geoserver.service.disabled' to be unset > 07 Oct 07:48:46 TRACE [geoserver.platform] - Found System environment > variable : 'org.geoserver.service.disabled' to be unset > 07 Oct 07:48:46 DEBUG [geoserver.requests] - Query is > org.geoserver.wfs.request.Query$WFS20@4a3bf0b0 > To gt2: Query: > feature type: windproc_view > filter: [[ geom bbox ReferencedEnvelope[-12.875 : 42.125, 26.125 : > 55.125] DefaultGeographicCRS[EPSG:WGS 84] AXIS["Geodetic longitude", EAST] > AXIS["Geodetic latitude", NORTH] ] AND [ reading_time = Sun May 27 13:00:00 > BST 2018 ]] > [properties: ALL ] > > On Sat, 7 Oct 2023 at 06:37, Dave Potts <mrdapo...@gmail.com> wrote: > >> 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 > -- Ian Turton
_______________________________________________ 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
