Wrong displayed date using SQL Server but correct with H2

[Alex1]

Hi,

When I configure the engine to use SQL Server and start a process, the created date of the user task associated with the process is set to two days ago:

Then, when relaunching Tomcat with H2, and doing the same as above I obtain the expected creation date:

What is causing this bad behavior ?
Thanks

[hassang]

Hi @Alex1,

See below posts…

Timestamp error with SQL Server DB Backend

Hi @stschoenig… We have faced excatly the same issue with SQL Server 2012 and camunda 7.10 And the solution was to change any datetime2 column’s type to datetime. Edited:

Timestamp error with SQL Server DB Backend

Hi @stschoenig It seems … it is related to the JDBC driver See below post… https://stackoverflow.com/questions/11296606/dates-consistently-two-days-off/11452599#11452599

[Alex1]

Hi @hassang ,

Thanks for your help!
Indeed, upgrading the JDBC driver does fix the problem.
I replaced the old sqljdbc4-3.0.jar with the mssql-jdbc-7.2.2.jre8.jar I found here and now the correct date is displayed.