I have gathered data in last 8 month and database in now about 25GB. Last night i tried to visualize it with grafana and puzzled why it not work before i noticed that i have saved data with wrong timestamp whole time. See below:
select last(Var01) from "TEST" name: TEST time last ---- ---- 1539078061 0.0002889 precision rfc3339 select last(Var01) from "TEST" name: TEST time last ---- ---- 1970-01-01T00:00:01.539078121Z 0.0002889
Is there a way to fix timestamps (i assume that equation is something like: newTimeStamp = 1000 000*oldTimeStamp IF there in not any clever way to do it) directly in influx CLI or should i write short python script for it?