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.

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	158	8 April 2023
Time Stamp and Influx DB problem General	48	10335	20 June 2022
Timestamps not being recorded correctly General influxdb	19	285	22 June 2023
Time seems off when writing to InfluxDB General	4	127	31 May 2023
InfluxDB on a Raspberry Pi General database	66	5537	16 October 2021

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