[Geoserver-devel] [JIRA] (GEOS-10947) The difference of the WFS service date is one day

[_Failed_to_Retrieve]

王晓锋 created an issue

GeoServer / GEOS-10947

The difference of the WFS service date is one day

Issue Type:	Bug
Affects Versions:	2.23.0
Assignee:	Unassigned
Components:	PostGIS, wfs-datastore
Created:	20/Apr/23 8:24 AM
Environment:	WindowServer 2008 D2 postgresql-x64-15 postgis3.3
Priority:	Highest
Reporter:	王晓锋

I use the GetFeature method of wfs service, the search date condition is ydjgsj=2014-12-15, but the return result is 2014-12-14Z, and the data record in postgresql is 2014-12-15, what is the reason? request: http://10.0.0.126:8080/geoserver/test/ows?typename=test:gd3&REQUEST=GetFeature&resulttype=results&outputformat=GML3&version=2.0.0&service=WFS&srsname=EPSG:4526&filter=<fes:Filter xmlns:xs=“http://www.w3.org/2001/XMLSchema” xmlns:fes=“http://www.opengis.net/fes/2.0” xmlns:gml=“http://www.opengis.net/gml/3.2”><fes:And><fes:PropertyIsEqualTo matchAction=“Any” matchCase=“true”><fes:ValueReference>ydjgsj</fes:ValueReference><fes:Literal>2014-12-15</fes:Literal></fes:PropertyIsEqualTo><fes:PropertyIsEqualTo matchAction=“Any” matchCase=“true”><fes:ValueReference>status</fes:ValueReference><fes:Literal>2</fes:Literal></fes:PropertyIsEqualTo></fes:And></fes:Filter> response: <?xml version=“1.0” encoding=“UTF-8”?> <wfs:FeatureCollection xmlns:xs=“http://www.w3.org/2001/XMLSchema” xmlns:test=“www.test.com” xmlns:wfs=“http://www.opengis.net/wfs” xmlns:gml=“http://www.opengis.net/gml” xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance” numberOfFeatures=“1” timeStamp=“2023-04-20T02:29:02.225Z” xsi:schemaLocation=“http://www.opengis.net/wfs http://10.0.0.126:8080/geoserver/schemas/wfs/1.1.0/wfs.xsd www.test.com http://10.0.0.126:8080/geoserver/test/wfs?service=WFS&amp;version=2.0.0&amp;request=DescribeFeatureType&amp;typeName=test%3Agd3”> <gml:featureMembers> <test:gd3 gml:id=“gd3.12439”> <test:id>36532</test:id> <test:ydjgsj>2014-12-14Z</test:ydjgsj> <test:geom> <gml:MultiSurface srsName=“http://www.opengis.net/gml/srs/epsg.xml#4526” srsDimension=“2”> <gml:surfaceMember> <gml:Polygon> <gml:exterior> <gml:LinearRing> <gml:posList>x y</gml:posList> </gml:LinearRing> </gml:exterior> </gml:Polygon> </gml:surfaceMember> </gml:MultiSurface> </test:geom> <test:area2>xxxx</test:area2> </test:gd3> </gml:featureMembers> </wfs:FeatureCollection>

Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS

This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100222-sha1:57eb20e)

[Humphries_Graham]

This is not a question for the developer mailing list. It should be on the Geoserver user list.

Anyway the Z at the end of date string would seem to indicate it is ‘Zulu’ time meaning that there is zero offset from UTC time. If you are east of there then dates will appear to be for the previous day until the time of day is greater than the offset time of your location.

Eg. I am in Eastern Australia where the time offset from UTC is +10 hours, so dates will show as the previous day until 10:00am

Regards,

Graham Humphries

(attachments)

···

From: 王晓锋 (JIRA) via Geoserver-devel geoserver-devel@lists.sourceforge.net
Sent: Thursday, 20 April 2023 4:24 PM
To: geoserver-devel@lists.sourceforge.net
Subject: [Geoserver-devel] [JIRA] (GEOS-10947) The difference of the WFS service date is one day

王晓锋 created an issue

GeoServer / GEOS-10947

The difference of the WFS service date is one day

Issue Type:	Bug
Affects Versions:	2.23.0
Assignee:	Unassigned
Components:	PostGIS, wfs-datastore
Created:	20/Apr/23 8:24 AM
Environment:	WindowServer 2008 D2 postgresql-x64-15 postgis3.3
Priority:	Highest
Reporter:	王晓锋

I use the GetFeature method of wfs service, the search date condition is ydjgsj=2014-12-15, but the return result is 2014-12-14Z, and the data record in postgresql is 2014-12-15, what is the reason? request: http://10.0.0.126:8080/geoserver/test/ows?typename=test:gd3&REQUEST=GetFeature&resulttype=results&outputformat=GML3&version=2.0.0&service=WFS&srsname=EPSG:4526&filter=<fes:Filter xmlns:xs=“http://www.w3.org/2001/XMLSchema” xmlns:fes=“http://www.opengis.net/fes/2.0” xmlns:gml=“http://www.opengis.net/gml/3.2”><fes:And><fes:PropertyIsEqualTo matchAction=“Any” matchCase=“true”><fes:ValueReference>ydjgsj</fes:ValueReference><fes:Literal>2014-12-15</fes:Literal></fes:PropertyIsEqualTo><fes:PropertyIsEqualTo matchAction=“Any” matchCase=“true”><fes:ValueReference>status</fes:ValueReference><fes:Literal>2</fes:Literal></fes:PropertyIsEqualTo></fes:And></fes:Filter> response: <?xml version=“1.0” encoding=“UTF-8”?> <wfs:FeatureCollection xmlns:xs=“http://www.w3.org/2001/XMLSchema” xmlns:test=“www.test.com” xmlns:wfs=“http://www.opengis.net/wfs” xmlns:gml=“http://www.opengis.net/gml” xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance” numberOfFeatures=“1” timeStamp=“2023-04-20T02:29:02.225Z” xsi:schemaLocation=“http://www.opengis.net/wfs http://10.0.0.126:8080/geoserver/schemas/wfs/1.1.0/wfs.xsd www.test.com http://10.0.0.126:8080/geoserver/test/wfs?service=WFS&amp;version=2.0.0&amp;request=DescribeFeatureType&amp;typeName=test%3Agd3”> <gml:featureMembers> <test:gd3 gml:id=“gd3.12439”> <test:id>36532</test:id> <test:ydjgsj>2014-12-14Z</test:ydjgsj> <test:geom> <gml:MultiSurface srsName=“http://www.opengis.net/gml/srs/epsg.xml#4526” srsDimension=“2”> <gml:surfaceMember> <gml:Polygon> <gml:exterior> <gml:LinearRing> <gml:posList>x y</gml:posList> </gml:LinearRing> </gml:exterior> </gml:Polygon> </gml:surfaceMember> </gml:MultiSurface> </test:geom> <test:area2>xxxx</test:area2> </test:gd3> </gml:featureMembers> </wfs:FeatureCollection>

Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS

This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100222-sha1:57eb20e)