search

mblackstock / node-red-contrib-influxdb

Node-RED nodes to save and query data from an influxdb time series database
Other
64 stars 46 forks source link

Timestamp field is not storing properly in influxDB bulk node #116

Closed satyamtpatel closed 2 years ago

satyamtpatel commented 2 years ago

We are inserting records from the past but time field is not displaying correct information.

For e.g.

We are sending unix time in msg.payload as a timestamp: 1598846404

Date and time (GMT): Monday, August 31, 2020 4:00:04 Date and time (your time zone): Monday, August 31, 2020 0:00:04 GMT-04:00

but in the influxDB it is storing as "2020-08-31T10:54:21.133Z"

Can you please provide your assistance?

mblackstock commented 2 years ago

Please ensure the timestamp has the correct precision e.g. milliseconds and not seconds and provide a sample flow illustrating the problem.

On Wed., Apr. 6, 2022, 3:40 p.m. satyamtpatel, @.***> wrote:

We are inserting records from the past but time field is not displaying correct information.

For e.g.

We are sending unix time in msg.payload as a timestamp: 1598846404

Date and time (GMT): Monday, August 31, 2020 4:00:04 Date and time (your time zone): Monday, August 31, 2020 0:00:04 GMT-04:00

but in the influxDB it is storing as "2020-08-31T10:54:21.133Z"

Can you please provide your assistance?

— Reply to this email directly, view it on GitHub https://github.com/mblackstock/node-red-contrib-influxdb/issues/116, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAFMY6HYLYBUCHHK62WXKL3VDYHGRANCNFSM5SXQEDQA . You are receiving this because you are subscribed to this thread.Message ID: @.***>

mblackstock commented 2 years ago

Closing, will reopen if I get more information.

satyamtpatel commented 2 years ago

Sorry, I was able to resolve the issue. It is precision issue. Thanks for your support.