王晓锋 ( https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=712020%3Ab219e265-c502-4aff-9420-1cef0320452b ) *created* an issue
GeoServer ( https://osgeo-org.atlassian.net/browse/GEOS?atlOrigin=eyJpIjoiZmJlMThlMDZhZDBkNDAyYWIwM2JmNmFkMTg1YTFiYzkiLCJwIjoiaiJ9 ) / Bug ( https://osgeo-org.atlassian.net/browse/GEOS-10947?atlOrigin=eyJpIjoiZmJlMThlMDZhZDBkNDAyYWIwM2JmNmFkMTg1YTFiYzkiLCJwIjoiaiJ9 ) GEOS-10947 ( https://osgeo-org.atlassian.net/browse/GEOS-10947?atlOrigin=eyJpIjoiZmJlMThlMDZhZDBkNDAyYWIwM2JmNmFkMTg1YTFiYzkiLCJwIjoiaiJ9 ) The difference of the WFS service date is one day ( https://osgeo-org.atlassian.net/browse/GEOS-10947?atlOrigin=eyJpIjoiZmJlMThlMDZhZDBkNDAyYWIwM2JmNmFkMTg1YTFiYzkiLCJwIjoiaiJ9 ) 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: 王晓锋 ( https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=712020%3Ab219e265-c502-4aff-9420-1cef0320452b ) 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&version=2.0.0&request=DescribeFeatureType&typeName=test%3Agd3 ( http://10.0.0.126:8080/geoserver/test/wfs?service=WFS&version=2.0.0&request=DescribeFeatureType&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> ( https://osgeo-org.atlassian.net/browse/GEOS-10947#add-comment?atlOrigin=eyJpIjoiZmJlMThlMDZhZDBkNDAyYWIwM2JmNmFkMTg1YTFiYzkiLCJwIjoiaiJ9 ) Add Comment ( https://osgeo-org.atlassian.net/browse/GEOS-10947#add-comment?atlOrigin=eyJpIjoiZmJlMThlMDZhZDBkNDAyYWIwM2JmNmFkMTg1YTFiYzkiLCJwIjoiaiJ9 ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.core&referrer=utm_source%3DNotificationLink%26utm_medium%3DEmail ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailNotificationLink&mt=8 ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100222- sha1:57eb20e )
_______________________________________________ Geoserver-devel mailing list Geoserver-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-devel