Hi Mark, Thanks a lot for helping us out for this one. We saved a lot of time!
Cheers, Francis Van: Mark Prins <[email protected]> Verzonden: dinsdag 26 november 2019 12:28 Aan: geoserver-users <[email protected]> Onderwerp: Re: [Geoserver-users] geoserver differs two days from sql 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]<mailto:[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 [cid:[email protected]] Open Layers Geoserver version 2.13.2 [cid:[email protected]] Can anyone explain this? Thanks a lot, Met vriendelijke groeten, Francis Vanden Bulcke Technisch Applicatiespecialist GIS Projecten, Ontwikkeling en Nazorg Domein DIG (Data, Informatie en GIS) Digipolis Bellevue 1, 9050 Gent Tel.: +32 (0)92660972 http://www.digipolis.gent<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]<mailto:[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
