We had this 2-years-off problem (with 2.16.0 and sql server - version unknown, no SDE involved I think) at a client site recently and it appears to have been solved bij updating the JDBC driver (from the legacy 4.x version to the open source 8.1.0-preview release)
download here: https://github.com/microsoft/mssql-jdbc/releases/tag/v8.1.0 Op ma 25 nov. 2019 om 14:51 schreef Vanden Bulcke Francis <[email protected]>: > Hi All, > > > > A lot of our data in geoserver comes from Arcgis SDE database in SQL. We > discovered lately that there is a problem with datetime fields. > > > > When we use OpenLayers or every other option to consult the geoserver > data: the date in geosever differs two days from Arcgis SDE database. > > > > See the example below: > > > > *SDE database SQL Server 2016* > > > > *Open Layers Geoserver version 2.13.2* > > > > > > Can anyone explain this? > > > > Thanks a lot, > > > > Met vriendelijke groeten, > > > > *Francis Vanden Bulcke* > > Technisch Applicatiespecialist GIS > > Projecten, Ontwikkeling en Nazorg > Domein DIG (*D*ata, *I*nformatie en *G*IS) > > > > *Digipolis* > Bellevue 1, 9050 Gent > Tel.: +32 (0)92660972 > http://www.digipolis.gent > Disclaimer <http://www.digipolis.be/disclaimer> > > > _______________________________________________ > 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 > > > [email protected] > https://lists.sourceforge.net/lists/listinfo/geoserver-users > -- Disclaimer; This message is just a reflection of what I thought at the time of sending. The message may contain information that is not intended for you or that you don't understand.
_______________________________________________ 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 [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
