Hello,
We started a new solution a few months ago, and when moving from our test environment to the production environment, this date problem occurs.
Both environment uses MSSQL Server and SQL Server Management studio with version 10.50.1617 on our production environment and version 10.50.16000.1 on our testing environment. For information, our third server, used for pre-production behaves as expected, and everything is ok in developer using Servoy 7.4.
The problem, as strange as it may be, is that the dates from one server to the other differs from 2 days, when showed on a servoy form. We backup and restored the database from our production environment to the testing one, and the data differs from one to the other with the same datas. The date is thus correct in testing/pre-prod and servoy developer but differs in production with this problematic bug.
The solution deployed is the same, the driver and Servoy versions are the same, the servoy locale settings are the same, so what may happen according to you ?
Additonnal notes : This does happen with this new solution where dateTime gets converted to dateTime2 in MSSQL which is not the case with our previous solutions. We are using the microsoft driver, not the jtds.
Thank you, I'm lost as you may imagine...
Here are 2 screenshots from the 2 environments