Hi guys I’m new here in the forum, use in InfluxDB (1.x) however already for some time. Now I am facing a problem that I just don’t understand. I couldn’t find anything similar in the forum (maybe I didn’t search for the right keyword).
I would appreciate your help very much.
I use InfluxDB in version 1.8, I have a database in which I store log files via Python. All timestamps are UTC. I now want to know the number of certain values in my fields over time. The following queries which I would expect to return the same, return something different:
First Query: As you can see there is a big difference in the results. I was a bit unsure about the timestamp as the second one is UTC and the first is my timezone (Europe/Berlin), thats why i tried this query.
Second Query: I just added the ‘tz’ at the end. For me this looks like, that Influx is just adapting the time. The query result stays the same.
Third Query: Now on the this query it gets really strange (well at least for me). I added the ‘tz’ parameter to my first query and i get a different result.
So there is a difference for Influx if i query with a custom time range or the predefined ‘now()’ keyword. But i would expect if i take the same time (like i do for my sample queries) for a custom range as for the predefined, i get the same results. I now that the returned data for the custom range is right but why i didn´t get that data on the predefined ‘time now()’.
Thank you in advance for your help