# Timestamps in Influx differ by minutes (vs those loaded in NR)

**URL:** https://discourse.nodered.org/t/timestamps-in-influx-differ-by-minutes-vs-those-loaded-in-nr/65004
**Category:** General
**Created:** [12 July 2022 12:28 UTC](https://discourse.nodered.org/t/timestamps-in-influx-differ-by-minutes-vs-those-loaded-in-nr/65004 "2022-07-12T12:28:13Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![grant1](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/grant1/32/49890_2.png) [@grant1](https://discourse.nodered.org/u/grant1)
#### Post date: [12 July 2022 12:28 UTC](https://discourse.nodered.org/t/timestamps-in-influx-differ-by-minutes-vs-those-loaded-in-nr/65004/1 "2022-07-12T12:28:13Z")

</div>

I am using the [InfluxDB out node](https://flows.nodered.org/node/node-red-contrib-influxdb) to populate some values with an associated timestamp. The timestamp is exactly on the hour, every hour. In the debug pane, it appears fine:

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/f/c/fc02cd881e8a18ec4bc16b7f4beba00637f88944.png)

but in InfluxDB, the timestamp (\_time) values are off by a few minutes each:

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/1/8/18e4f4b648187d9283a42863aeee43ac91647fd4.png)

Does anyone have some insight as to why this is happening, and what is the remedy?

FWIW, my node has the Time Precision set to milliseconds...  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/5/e/5e35ac5c2ae57c88e4af2c3489562fa9a08a9170.png)  
which agrees with the timestamps in the debug pane:  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/6/7/6773f03c1884476bc153d2c4cfd222d30f54c7e0.png)

---

<div class="post-metadata">

### Author: ![grant1](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/grant1/32/49890_2.png) [@grant1](https://discourse.nodered.org/u/grant1)
#### Post date: [12 July 2022 13:21 UTC](https://discourse.nodered.org/t/timestamps-in-influx-differ-by-minutes-vs-those-loaded-in-nr/65004/2 "2022-07-12T13:21:54Z")

</div>

I figured it out. There was ` |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)` being applied. Once I removed that, it renders the \_time field exactly as it should:

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/d/9/d991bba60a43cb54daa7c1279530d3b03d01667d.png)

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)
#### Post date: [26 July 2022 13:22 UTC](https://discourse.nodered.org/t/timestamps-in-influx-differ-by-minutes-vs-those-loaded-in-nr/65004/3 "2022-07-26T13:22:48Z")

</div>

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.