I have a new Docker server with data migrated from a H2 Traccar server. Both Traccar versions were current 5.4 but the old server has its time set as UTC+10/11 (with daylight savings) and the new server is using UTC (as it should be!). On start-up on the new server, all the existing device statuses were showing as "in 9 hours time".. i.e in the future.. (the time difference being after delay due to conversion time) - The devices definitely use UTC.
I read that the times are always stored as UTC in the database so confused as to how this is happening??
The old server (Linux) reports its time zone as "AEDT +1100".
Do I need to convert some data on copy over?
That's a problem likely related to H2 database. They store timestamps in the local server timezone.
I have a new Docker server with data migrated from a H2 Traccar server. Both Traccar versions were current 5.4 but the old server has its time set as UTC+10/11 (with daylight savings) and the new server is using UTC (as it should be!). On start-up on the new server, all the existing device statuses were showing as "in 9 hours time".. i.e in the future.. (the time difference being after delay due to conversion time) - The devices definitely use UTC.
I read that the times are always stored as UTC in the database so confused as to how this is happening??
The old server (Linux) reports its time zone as "AEDT +1100".
Do I need to convert some data on copy over?