I am using Raspberry 4 to run Node-Red, Influxdb and Grafana. The Pi is set up on Johannasburg South Africa time zone. The problem if I query the data are a few hours off, I suspect somehow the data are stored with the incorrect time stamp. Any one have an idea where to look for how this happens? …

Ok found the problem. It is the Influxdb node 'node-red-contrib-influxdb' can not be stet to nanosecond for the precision, not that I needed it to that accuracy. Problem solve by setting to microsecond. [image] Thank you for everyone's input.

Are you running NR in Docker? If so, the TZ environment variables might be wrong or not set. I've recently discovered that the time zone in a container is not forced to be the same as the host machine without a TZ variable in your docker config..

I don't think it is the problem in the other thread, that was specifically the influxdb explorer tool that was showing confusing timestamps. This is showing it in grafana.

@ScheepersJohan as well as answering the docker question, what timezone is the machine running the browser set to?

Since you are letting influx add the timestamps that should not make any difference, unless you started with it in nanosecs, recorded some data, and then changed it, which might mess things up I suppose. If, starting from scratch, it does make a difference then that is a bug that you should report. …

Node-RED

Node-RED Forum

Node-Red -> Infuxdb - Timestamp out of date

General

edje11 24 April 2023 09:24 3

Have a look at this topic, looks like the same problem.

Topic		Replies	Views
NodeRED > Influx - Time way ahead General database	8	257	8 April 2023
Time seems off when writing to InfluxDB General	4	184	31 May 2023
Influxdb showing arbitrary timestamps General	14	551	12 December 2022
Timestamps not being recorded correctly General influxdb	19	507	22 June 2023
Wrong timezone in Node-RED General	4	578	9 November 2022

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Node-Red -> Infuxdb - Timestamp out of date

Related topics