# Nanosecond Precision with InfluxDB
**URL:** https://discourse.nodered.org/t/nanosecond-precision-with-influxdb/65278
**Category:** General
**Tags:** database
**Created:** [18 July 2022 16:30 UTC](https://discourse.nodered.org/t/nanosecond-precision-with-influxdb/65278 "2022-07-18T16:30:58Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@fludki](https://discourse.nodered.org/u/fludki)
#### Post date: [18 July 2022 16:30 UTC](https://discourse.nodered.org/t/nanosecond-precision-with-influxdb/65278/1 "2022-07-18T16:30:58Z")
I am struggling with ns resolution timestamps from an influxDB (node-red-contrib-influxdb). The data is high-resolution acceleration data with a sampling frequency of several kHz. To make exact timestamps I would need ns resolution. Saving the data to the database works and in the DB it is stored with correct precision (see picture). After the query, the last digits are replaced by zeros. Any guesses what I can do in this particular case?
Thanks in advance!
---
### Author:  [@fludki](https://discourse.nodered.org/u/fludki)
#### Post date: [18 July 2022 16:31 UTC](https://discourse.nodered.org/t/nanosecond-precision-with-influxdb/65278/2 "2022-07-18T16:31:47Z")
How it is stored in the DB:
---
### Author:  [@HaroldPetersInskipp](https://discourse.nodered.org/u/HaroldPetersInskipp)
#### Post date: [18 July 2022 17:16 UTC](https://discourse.nodered.org/t/nanosecond-precision-with-influxdb/65278/3 "2022-07-18T17:16:19Z")
I'm still somewhat new (so I could be way off), but could you be running into an issue with [Number.MAX\_SAFE\_INTEGER - JavaScript | MDN](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Number/MAX_SAFE_INTEGER)
Your `msg.payload.results[0].series[0].values[7][0]` is set to:
`1658150533469000000`
but the max is
`9007199254740991`
---
### Author:  [@fludki](https://discourse.nodered.org/u/fludki)
#### Post date: [18 July 2022 19:50 UTC](https://discourse.nodered.org/t/nanosecond-precision-with-influxdb/65278/4 "2022-07-18T19:50:43Z")
I think you are right! Thanks a lot! Unfortunately I cant really change that. I found the part in the influx node-code:
```auto
if (rawOutput) {
var queryPromise = client.queryRaw(query, queryOptions);
} else {
var queryPromise = client.query(query, queryOptions);
}
queryPromise.then(function (results) {
msg.payload = results;
send(msg);
done();
```
I think I need to change the type of results to string or BigInt. Unfortunately this is an object. Any idea how to solve that?
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [18 July 2022 20:06 UTC](https://discourse.nodered.org/t/nanosecond-precision-with-influxdb/65278/5 "2022-07-18T20:06:28Z")
What are you going to do with the data once you get it into node-red?
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [18 July 2022 20:12 UTC](https://discourse.nodered.org/t/nanosecond-precision-with-influxdb/65278/6 "2022-07-18T20:12:51Z")
Also what do you see if you select Raw Output in the Influx In node?
---
### Author:  [@fludki](https://discourse.nodered.org/u/fludki)
#### Post date: [19 July 2022 05:59 UTC](https://discourse.nodered.org/t/nanosecond-precision-with-influxdb/65278/7 "2022-07-19T05:59:38Z")
I get the data via MQTT and want to store it in a database first. Than you should be able to retrieve the data from the DB via dashboard and make a csv export.
The picture in the first post shows the raw output. Below is the formatet output. Then it also formats the timestamp another way:
---
### Author:  [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)
#### Post date: [19 July 2022 06:24 UTC](https://discourse.nodered.org/t/nanosecond-precision-with-influxdb/65278/8 "2022-07-19T06:24:36Z")
If the influxdb node is getting in the way, don't forget that you can submit data to InfluxDB directly via its REST API. The line protocol is text rather than anything else so you can submit data to ns precision that way.
[InfluxDB line protocol tutorial | InfluxDB OSS 1.8 Documentation (influxdata.com)](https://docs.influxdata.com/influxdb/v1.8/write_protocols/line_protocol_tutorial/)
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [19 July 2022 08:31 UTC](https://discourse.nodered.org/t/nanosecond-precision-with-influxdb/65278/9 "2022-07-19T08:31:28Z")
> [@fludki](#):
>
> I get the data via MQTT and want to store it in a database first
Why are you getting it out of influx and then storing it in a database? It is already in a database (influx).
If you do need to store it in another db then will that db support those large numbers?
What are you going to do with the csv export?
As @TotallyInformation says, if you need to fetch the full precision timestamp you should be able to do it directly rather than using the influxdb node.
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [2 August 2022 08:31 UTC](https://discourse.nodered.org/t/nanosecond-precision-with-influxdb/65278/10 "2022-08-02T08:31:40Z")
This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.