# \#timestamp **URL:** https://community.influxdata.com/tag/timestamp/126.md [Latest](https://community.influxdata.com/latest.md) · [Categories](https://community.influxdata.com/categories.md) · [Tags](https://community.influxdata.com/tags.md) --- ## [aggregateWindow and managing queries in local time](https://community.influxdata.com/t/aggregatewindow-and-managing-queries-in-local-time/31848)
**Author:** [@Timmwardion](https://community.influxdata.com/u/Timmwardion)\ **Replies:** 2\ **Last updated:** [July 24, 2025, 11:05am UTC](https://community.influxdata.com/t/aggregatewindow-and-managing-queries-in-local-time/31848 "2025-07-24T11:05:03Z")
Hi All. I’m trying to work with data in local time (Australia/Melbourne, or AEST we are currently in daylight savings). I have some sensors that are writing data to influx in batches but those batches contain a timesta… --- ## [Influxdb seemingly not accepting timestamps](https://community.influxdata.com/t/influxdb-seemingly-not-accepting-timestamps/40180)
**Author:** [@fv0](https://community.influxdata.com/u/fv0)\ **Replies:** 1\ **Last updated:** [January 3, 2025, 3:30pm UTC](https://community.influxdata.com/t/influxdb-seemingly-not-accepting-timestamps/40180 "2025-01-03T15:30:04Z")
Hello, I am using InfluxDB v2.7.11 Server: fbf5d4a Frontend: f4b5694 And influxdb-client Version: 1.48.0 I am generating line protocol queries of the form my\_stats,source=my\_stats,uuid=05764e13-5113-4fd3-84f8-295… --- ## [Influxdb 2.1.1 Internal Server Error (Timestamp related)](https://community.influxdata.com/t/influxdb-2-1-1-internal-server-error-timestamp-related/23994)
**Author:** [@t481](https://community.influxdata.com/u/t481)\ **Replies:** 15\ **Last updated:** [December 27, 2024, 12:01am UTC](https://community.influxdata.com/t/influxdb-2-1-1-internal-server-error-timestamp-related/23994 "2024-12-27T00:01:13Z")
Hello, I’m using curl to add data to my bucket and I’m getting a runtime error “integer divide by zero” HTTP/1.1 500 Internal Server Error Content-Length: 168 Content-Type: application/json; charset=utf-8 Date: Wed… --- ## [Use InfluxDB's timestamp, instead of OS clock](https://community.influxdata.com/t/use-influxdbs-timestamp-instead-of-os-clock/39210)
**Author:** [@shan1](https://community.influxdata.com/u/shan1)\ **Replies:** 6\ **Last updated:** [December 12, 2024, 12:18am UTC](https://community.influxdata.com/t/use-influxdbs-timestamp-instead-of-os-clock/39210 "2024-12-12T00:18:42Z")
Hello, I have to collect system status from remote server’s telegraf, but since this server dedicated to test, this server’s clock changes frequently. So the collected data became chaotic, making unable to monitor this … --- ## [Alert to detect wrong timestamp](https://community.influxdata.com/t/alert-to-detect-wrong-timestamp/39766)
**Author:** [@shan1](https://community.influxdata.com/u/shan1)\ **Replies:** 3\ **Last updated:** [December 11, 2024, 4:37am UTC](https://community.influxdata.com/t/alert-to-detect-wrong-timestamp/39766 "2024-12-11T04:37:09Z")
Hi, I’d like to make an alert that monitor if there’s any data coming with wrong timestamp. For example, if there’s a server has wrong OS clock setting, like, it’s a day behind than real time, it’s telegraf will send an… --- ## [Timestamp mismatch before and after injection](https://community.influxdata.com/t/timestamp-mismatch-before-and-after-injection/39576)
**Author:** [@Sathyan](https://community.influxdata.com/u/Sathyan)\ **Replies:** 0\ **Last updated:** [November 28, 2024, 12:27pm UTC](https://community.influxdata.com/t/timestamp-mismatch-before-and-after-injection/39576 "2024-11-28T12:27:42Z")
Hi Community, I have been using influxDB for storing annd visualisation of time-series data. Here I have a influxdb having two buckets namely A and B, the bucket A has data received from data provider in a certain form… --- ## [JMeter, Influx2, and InfluxQL](https://community.influxdata.com/t/jmeter-influx2-and-influxql/38881)
**Author:** [@peecee](https://community.influxdata.com/u/peecee)\ **Replies:** 3\ **Last updated:** [October 29, 2024, 1:20pm UTC](https://community.influxdata.com/t/jmeter-influx2-and-influxql/38881 "2024-10-29T13:20:06Z")
Hiya, I am running into issues with Influxql and the time field. I tried to make a subquery using the time field, but I’ve run into errors (because time cannot be selected as a scalar?). I am using the JMeter influx dr… --- ## [How do you handle time sync issues?](https://community.influxdata.com/t/how-do-you-handle-time-sync-issues/37695)
**Author:** [@ticchioned](https://community.influxdata.com/u/ticchioned)\ **Replies:** 3\ **Last updated:** [October 14, 2024, 7:48pm UTC](https://community.influxdata.com/t/how-do-you-handle-time-sync-issues/37695 "2024-10-14T19:48:17Z")
I was wondering if anyone has run into a similar issue and knows a way around this issue. I have a client that talks to InfluxDB. InfluxDB is on a different server than the client. The InfluxDB server is locked down a… --- ## [Query a single time point](https://community.influxdata.com/t/query-a-single-time-point/35649)
**Author:** [@JasonJ55](https://community.influxdata.com/u/JasonJ55)\ **Replies:** 1\ **Last updated:** [September 16, 2024, 6:58pm UTC](https://community.influxdata.com/t/query-a-single-time-point/35649 "2024-09-16T18:58:51Z")
I’m using Flux within the C# client. I’m trying to query on a single time point but cannot get it to work. There’s a lot of data involved so I need to keep the range to a single time point if possible Let’s say I have … --- ## [Kafka\_consumer does not read timestamp from Kafka events](https://community.influxdata.com/t/kafka-consumer-does-not-read-timestamp-from-kafka-events/35442)
**Author:** [@brennerm](https://community.influxdata.com/u/brennerm)\ **Replies:** 2\ **Last updated:** [August 27, 2024, 2:07pm UTC](https://community.influxdata.com/t/kafka-consumer-does-not-read-timestamp-from-kafka-events/35442 "2024-08-27T14:07:48Z")
Hey folks, my goal is to pull metric events from a Kafka cluster and ingest them into an InfluxDB bucket. The timestamp of each metric point should be taken from the Kafka event and is not part of the event payload. Is … --- ## [InfluxDB query with Python - time difference of 2h](https://community.influxdata.com/t/influxdb-query-with-python-time-difference-of-2h/32169)
**Author:** [@Xtremdiver](https://community.influxdata.com/u/Xtremdiver)\ **Replies:** 1\ **Last updated:** [November 20, 2023, 7:40am UTC](https://community.influxdata.com/t/influxdb-query-with-python-time-difference-of-2h/32169 "2023-11-20T07:40:09Z")
Hello dear community, I found a discrepancy between the query within the Influx environment and via SQL query (with Python and the InfluxDBClient module) and I don’t know how to fix this. I executed my query within the… --- ## ["timestamp" field reserved?](https://community.influxdata.com/t/timestamp-field-reserved/32047)
**Author:** [@OmariC](https://community.influxdata.com/u/OmariC)\ **Replies:** 0\ **Last updated:** [November 3, 2023, 6:56pm UTC](https://community.influxdata.com/t/timestamp-field-reserved/32047 "2023-11-03T18:56:03Z")
Our code saves several fields to InfluxDB. We changed our timestamp field to be named literally timestamp and it wouldn’t show up in Influx. After renaming it, it showed up. This leads me to believe timestamp is a reserv… --- ## [Flux query to return time in different zone](https://community.influxdata.com/t/flux-query-to-return-time-in-different-zone/31498)
**Author:** [@Nam\_Giang](https://community.influxdata.com/u/Nam_Giang)\ **Replies:** 6\ **Last updated:** [September 18, 2023, 12:49pm UTC](https://community.influxdata.com/t/flux-query-to-return-time-in-different-zone/31498 "2023-09-18T12:49:33Z")
Hi there, I have a flux query that returns a time column that ends with ‘:00Z’. Is there a way for the query to return that column but ends with for example ‘:-00:08’? Or something that’s not ‘Z’ - UTC? Thanks --- ## [Struggling with date format conversion](https://community.influxdata.com/t/struggling-with-date-format-conversion/28785)
**Author:** [@MrEvilcK](https://community.influxdata.com/u/MrEvilcK)\ **Replies:** 1\ **Last updated:** [February 25, 2023, 11:45am UTC](https://community.influxdata.com/t/struggling-with-date-format-conversion/28785 "2023-02-25T11:45:42Z")
Hello I have a little problem with timestamp conversion. I’m trying to convert a timestamp that is stored in ISO8601/RFC3339 format as a string. basically i want to do something like this: from(bucket: "bucket") |\> … --- ## [Timestamps in relation to query method - they are different - DataExplorer confusion](https://community.influxdata.com/t/timestamps-in-relation-to-query-method-they-are-different-dataexplorer-confusion/28144)
**Author:** [@penholder](https://community.influxdata.com/u/penholder)\ **Replies:** 5\ **Last updated:** [January 18, 2023, 1:23am UTC](https://community.influxdata.com/t/timestamps-in-relation-to-query-method-they-are-different-dataexplorer-confusion/28144 "2023-01-18T01:23:12Z")
I have upgraded influxdb from 1.8 to 2.6 I use a lot sensors, some of them produce incorrect values or are delivered falsely by mqtt. Deleting those values have always been a very disturbing tasks with influxdb. I had … --- ## [Compensate for timezone when using window, integra, hourSelection and map](https://community.influxdata.com/t/compensate-for-timezone-when-using-window-integra-hourselection-and-map/26652)
**Author:** [@itsmaxdd](https://community.influxdata.com/u/itsmaxdd)\ **Replies:** 0\ **Last updated:** [September 21, 2022, 9:48am UTC](https://community.influxdata.com/t/compensate-for-timezone-when-using-window-integra-hourselection-and-map/26652 "2022-09-21T09:48:15Z")
Hello, in my setup i’m relying on window, integral, hourSelection and date. I’ve noticed that my data is saved in UTC but i live in a place which has a different timezone. Now if i start to window by day or performing… --- ## [Query: When was the last time it started to rain?](https://community.influxdata.com/t/query-when-was-the-last-time-it-started-to-rain/26419)
**Author:** [@Guido\_Berger](https://community.influxdata.com/u/Guido_Berger)\ **Replies:** 1\ **Last updated:** [September 6, 2022, 10:27pm UTC](https://community.influxdata.com/t/query-when-was-the-last-time-it-started-to-rain/26419 "2022-09-06T22:27:22Z")
Hi, I have a table which stores the current raining state. If it rains the \_value is 1, if it is dry the value is 0. E.g: \_value \_time 0 2022-09-06T11:00:00.000Z 1 2022-09-06T10:00:00.000Z … --- ## [Trailing zeros are added to timestamp](https://community.influxdata.com/t/trailing-zeros-are-added-to-timestamp/26281)
**Author:** [@Dirk\_Fries](https://community.influxdata.com/u/Dirk_Fries)\ **Replies:** 1\ **Last updated:** [August 26, 2022, 1:44pm UTC](https://community.influxdata.com/t/trailing-zeros-are-added-to-timestamp/26281 "2022-08-26T13:44:59Z")
Hi there, I got some strange issue with xml parsing in telegraf 1.23.4. I have an XML File with a timestamp in it like this timestamp=“1661517236” to parse this field I set in my telegraf config: timestamp = “//@tim… --- ## [Telegraf tail input parsing using GROK - Syntax help](https://community.influxdata.com/t/telegraf-tail-input-parsing-using-grok-syntax-help/25076)
**Author:** [@Tom\_Aspland](https://community.influxdata.com/u/Tom_Aspland)\ **Replies:** 5\ **Last updated:** [May 18, 2022, 11:10pm UTC](https://community.influxdata.com/t/telegraf-tail-input-parsing-using-grok-syntax-help/25076 "2022-05-18T23:10:36Z")
Hi, I am trying to get Telegraf (1.22.3 on Windows) to tail a game server log and extract the timestamp and on the same line entry parse out the tick rate (performance of the game server), example of log below: \[2022.0… --- ## [How to query last timestamp values?](https://community.influxdata.com/t/how-to-query-last-timestamp-values/24664)
**Author:** [@Amir\_Ft](https://community.influxdata.com/u/Amir_Ft)\ **Replies:** 1\ **Last updated:** [April 18, 2022, 5:46pm UTC](https://community.influxdata.com/t/how-to-query-last-timestamp-values/24664 "2022-04-18T17:46:07Z")
I am trying to query only the last point added to the database with a specific tag value. When I use last() function, it gives me the last value of all fields with that tag, which is not what I want. As a similar quest… --- ## [Import csv into influxDB. Datetime field parsing error](https://community.influxdata.com/t/import-csv-into-influxdb-datetime-field-parsing-error/23091)
**Author:** [@Jeong\_Hoon\_Lee](https://community.influxdata.com/u/Jeong_Hoon_Lee)\ **Replies:** 2\ **Last updated:** [December 23, 2021, 10:11am UTC](https://community.influxdata.com/t/import-csv-into-influxdb-datetime-field-parsing-error/23091 "2021-12-23T10:11:47Z")
Hello. I’m importing csv file into influxdb by influx cli But there is some parsing error. My datetime value is a ‘2021-01-01 07:40:00.000’ in csv file. So I’m using option ‘–header "#datatype dateTime:2006-01-02 12:0…