Nice, see the other answer from Mark Prins, looks like what you need is a driver upgrade.
Cheers, On Tue, 26 Nov 2019 at 09:30, Vanden Bulcke Francis <[email protected]> wrote: > Hi Gabriel, > > > > Thanks for your answer. > > We are not using the Arcsde connector, but have the sql server plugin > instead. > > > > Kind regards, > > Francis > > > > > > > > *Van:* Gabriel Roldan <[email protected]> > *Verzonden:* maandag 25 november 2019 15:37 > *Aan:* Vanden Bulcke Francis <[email protected]> > *CC:* geoserver-users <[email protected]> > *Onderwerp:* Re: [Geoserver-users] geoserver differs two days from sql > > > > Hello, > > > > so, are you using GeoServer's ArcSDE DataStore? > > > > I used to be the maintainer for the ArcSDE connector but I don't have > access > > to an ArcSDE instance anymore since a long time ago, so I'm afraid it's > gonna be hard > > to reproduce/help. Unless you have an instance I can hit from the internet? > > > > Cheers, > > Gabriel > > > > > > On Mon, 25 Nov 2019 at 10:53, Vanden Bulcke Francis < > [email protected]> wrote: > > 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 > > > > > -- > > Gabriel Roldán > -- Gabriel Roldán
_______________________________________________ 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
