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	194	8 April 2023
Time seems off when writing to InfluxDB General	4	168	31 May 2023
Influxdb showing arbitrary timestamps General	14	509	12 December 2022
Timestamps not being recorded correctly General influxdb	19	365	22 June 2023
Wrong timezone in Node-RED General	4	497	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