When I am trying to insert a old timestamp the values are not visible in influx DB var newMsg = {}; var data_time = msg.payload.data.substr(16, 8); var Temp = Number(hexTo8p8(msg.payload.data.substr(16 + 8, 4))); var Humidity = Number(hexTo8p8(msg.payload.data.substr(16 + 8 + 4, 4))); var da…

Moved to General - this is not an employment advert/offering.

What resolution have you configured the influx node to use?

[image] ankit.prasad: time: new Date(UTC_unix * 1000) The best way to investigate problems like this is to insert it into an empty measurement. Then you can inspect the whole dataset (1 record) and see what is going on. You could try time: new Date(UTC_unix * 1000) so pass it through as a…

Perhaps I am misunderstanding the problem. Do you mean they are all going in with the current time instead of the one you are passing in?

[image] Colin: What resolution have you configured the influx node yes its writing with the current timestamp instead of the time which is passed by the function

I haven't used influxdb 2 yet. Where is the time_in value coming from?

[{"id":"0e9164e2d746f7f0","type":"tab","label":"Flow 6","disabled":false,"info":"","env":[]},{"id":"420fd15204c8c209","type":"inject","z":"0e9164e2d746f7f0","name":"","props":[{"p":"payload"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"{\"msg\":\"dAck\",\"mac\":\"BC…

I meant that it doesn't exist in the sample object you posted, which I presume is what you are sending to influx.

What is the time_in field that is in the screenshot you posted?

Node-RED

Node-RED Forum

Node Red Custom Date Time insert into influx FLUX issue

General

grant1 26 March 2023 13:48 19

@ankit.prasad

You should be able to specify the time. See my post here.

Topic		Replies	Views
Working with Influxdb 2.x timestamp General	29	1633	8 August 2022
Time Stamp and Influx DB problem General	48	10962	20 June 2022
Need help inputting CSV data from OBD2 into influx from Chevy bolt General	23	2425	8 January 2020
Influxdb showing arbitrary timestamps General	13	571	13 October 2022
Hassio IOT: appropriate timestamp for Influxdb General	5	501	17 February 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 Custom Date Time insert into influx FLUX issue

Related topics