Changing an incorrectly fixed date

Dima2 years 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 Tananaev2 years ago

I think we're missing some context here.

Dima2 years ago

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