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 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 [https://secure.gravatar.com/avatar/e4584f846555a43e074694bcc52cff8c?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Fdefault-avatar-0.png] 王晓锋 <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]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]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<http://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> [Add Comment]<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) [Atlassian logo] ________________________________ CONFIDENTIALITY NOTICE AND DISCLAIMER The information in this transmission may be confidential and/or protected by legal professional privilege, and is intended only for the person or persons to whom it is addressed. If you are not such a person, you are warned that any disclosure, copying or dissemination of the information is unauthorised. If you have received the transmission in error, please immediately contact this office by telephone, fax or email, to inform us of the error and to enable arrangements to be made for the destruction of the transmission, or its return at our cost. No liability is accepted for any unauthorised use of the information contained in this transmission.
_______________________________________________ Geoserver-devel mailing list Geoserver-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-devel
