influxdb icon indicating copy to clipboard operation
influxdb copied to clipboard

Query results displays different time for a field "_time" depending on filter period

Open YuriyTigiev opened this issue 3 years ago • 1 comments

Query results displays different time for a field "_time" depending on filter period for the same raw data. Below two example

filter last 7d image

filter last 30 image

profiles.tar.gz iostat.txt

YuriyTigiev avatar Feb 27 '22 19:02 YuriyTigiev

I'm experiencing the same issue, and it's baffling me.

raw data: grafik

After the query: Unbenannt

I think it's a timezone issue, since the difference bw my local time and UTC is 2 hours, and that's the difference bw the raw data and the post-query _time column. Any ideas how to fix this issue? For my use-case, it works just fine if the data is represented with the correct _time column after the query, but I'd just sleep better at night if I knew how to also have correctly timed _time column in the raw data.

abedStatic avatar Jun 24 '22 07:06 abedStatic