Changing an incorrectly fixed date

Dimaa year ago

Data image

I made query:

update tc_positions set devicetime=date_add(devicetime , INTERVAL 7168 DAY), fixtime=date_add(fixtime , INTERVAL 7168 DAY) where deviceid=119;

It works. But I got minus distances.
Any chance to fix?

Anton Tananaeva year ago

I think we're missing some context here.

Dimaa year ago

Yes) I have an idea. I will check and write back.