iam currently trying to import old values but the timestamp is not correct.
This Timestamp 1588221453 should be 2020-04-30 06:37:33.004826
If you’re in UTC+2 timezone, yes (without the decimal seconds).
The date is correct in Influx but the time 6:12.
How do you get this result? How can we reproduce this answer? What query is
needed to get the time 06:12?
1574083831 should be Monday, 18. November 2019 14:30:31
For UTC+1, agreed.
but is shown as 14:25
Again, how can we reproduce this? Tell us what commands you are running so we
can see how you get these values.
I have imported via API to use seconds as precision but its the same whith
nanosecond converted timestamps. Adding entrys without timestamps gives
the current correct time.
I’m slightly bothered that you are referring to UTC+1 or UTC+2 timezones.
Almost all uses of InfluxDB require that the timestamps are in UTC, and you
need to bear that in mind when talking about what “actual time” the timestamp
That has nothing to do with offsets of a few minutes, however.