# \#time **URL:** https://community.influxdata.com/tag/time/26.md [Latest](https://community.influxdata.com/latest.md) · [Categories](https://community.influxdata.com/categories.md) · [Tags](https://community.influxdata.com/tags.md) --- ## [Aggregate/Group Data in Grafana with SQL](https://community.influxdata.com/t/aggregate-group-data-in-grafana-with-sql/58717)
**Author:** [@dominik.w](https://community.influxdata.com/u/dominik.w)\ **Replies:** 2\ **Last updated:** [September 2, 2026, 7:11am UTC](https://community.influxdata.com/t/aggregate-group-data-in-grafana-with-sql/58717 "2026-09-02T07:11:40Z")
Hi, I am using Influxdb3 to Store data from my Data logger. Writing to it with the following line Protocol spine,point=a\_voltage,unit=V value=230.5 171234567890123456 works fine. Currently I write multiple points ever… --- ## [How to efficiently query the latest data timestamp for pagination without knowing the data time range?](https://community.influxdata.com/t/how-to-efficiently-query-the-latest-data-timestamp-for-pagination-without-knowing-the-data-time-range/57830)
**Author:** [@shijianoo](https://community.influxdata.com/u/shijianoo)\ **Replies:** 2\ **Last updated:** [August 22, 2025, 1:21am UTC](https://community.influxdata.com/t/how-to-efficiently-query-the-latest-data-timestamp-for-pagination-without-knowing-the-data-time-range/57830 "2025-08-22T01:21:34Z")
I’m implementing a web frontend with pagination for InfluxDB data, but I’m facing a performance challenge when dealing with buckets that have unknown data time ranges. I’m using anchor-based pagination with the followin… --- ## [Internal Server Error when uploading data from multiple mf4 files](https://community.influxdata.com/t/internal-server-error-when-uploading-data-from-multiple-mf4-files/57770)
**Author:** [@akshay.magar](https://community.influxdata.com/u/akshay.magar)\ **Replies:** 0\ **Last updated:** [August 7, 2025, 12:03pm UTC](https://community.influxdata.com/t/internal-server-error-when-uploading-data-from-multiple-mf4-files/57770 "2025-08-07T12:03:11Z")
When using python script , i am trying to upload data from multiple mf4 files following error is occuring: Reason: Internal Server Error HTTP response headers: HTTPHeaderDict({‘Content-Type’: ‘application/json; charset=… --- ## [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… --- ## [Telegraf config with non standard timestamp format](https://community.influxdata.com/t/telegraf-config-with-non-standard-timestamp-format/56021)
**Author:** [@mnejmantowicz](https://community.influxdata.com/u/mnejmantowicz)\ **Replies:** 0\ **Last updated:** [January 23, 2025, 4:56pm UTC](https://community.influxdata.com/t/telegraf-config-with-non-standard-timestamp-format/56021 "2025-01-23T16:56:34Z")
Hello all. I’ve been scouring for a solution for several days now with no luck. I know the power of Telegraf but I have config paralysis now. Please help… I am consuming a REST api that returns JSON data like this: { … --- ## [Merge fields into one row, even with different timestamps?](https://community.influxdata.com/t/merge-fields-into-one-row-even-with-different-timestamps/55980)
**Author:** [@ticchioned](https://community.influxdata.com/u/ticchioned)\ **Replies:** 0\ **Last updated:** [January 22, 2025, 3:32pm UTC](https://community.influxdata.com/t/merge-fields-into-one-row-even-with-different-timestamps/55980 "2025-01-22T15:32:44Z")
I have what is likely a rather trivial question, but for some reason it has me stuck. I am trying to add some filters to my query. I would like to essentially be able to filter on all of my fields values, sort of like … --- ## [Flux not sorting data based on time, even using sort() function](https://community.influxdata.com/t/flux-not-sorting-data-based-on-time-even-using-sort-function/39306)
**Author:** [@symbox](https://community.influxdata.com/u/symbox)\ **Replies:** 0\ **Last updated:** [November 16, 2024, 6:26am UTC](https://community.influxdata.com/t/flux-not-sorting-data-based-on-time-even-using-sort-function/39306 "2024-11-16T06:26:08Z")
I’m trying to query data from InfluxDBv2 using Flux language. However, the data inserted to database is categorized by ‘user’ tag. So, the output data is not returned in time order value. Here is my query: from(bucket: … --- ## [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… --- ## [Timezone.location() function Error -\> malformed time zone information](https://community.influxdata.com/t/timezone-location-function-error-malformed-time-zone-information/38674)
**Author:** [@Outlawgentleman](https://community.influxdata.com/u/Outlawgentleman)\ **Replies:** 2\ **Last updated:** [October 8, 2024, 5:29pm UTC](https://community.influxdata.com/t/timezone-location-function-error-malformed-time-zone-information/38674 "2024-10-08T17:29:36Z")
Hello, since like 8 or 9 days i get the following errror in all my dashboards which have the timezone location function included. " malformed time zone information" My code includes the following lines: import “timez… --- ## [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 … --- ## [Timestamps lose precision in Flux Query through C# API](https://community.influxdata.com/t/timestamps-lose-precision-in-flux-query-through-c-api/35192)
**Author:** [@JasonJ55](https://community.influxdata.com/u/JasonJ55)\ **Replies:** 6\ **Last updated:** [August 15, 2024, 9:57pm UTC](https://community.influxdata.com/t/timestamps-lose-precision-in-flux-query-through-c-api/35192 "2024-08-15T21:57:37Z")
Hi, \[This is my first forum post as I’m still somewhat new to influxdb!\] Whenever I run a query, the returned timestamps are rounded to seconds, but I need them to be more precise. For example, here are two timestamps… --- ## [Time coming back as epoch ns now?](https://community.influxdata.com/t/time-coming-back-as-epoch-ns-now/34879)
**Author:** [@stanton009](https://community.influxdata.com/u/stanton009)\ **Replies:** 1\ **Last updated:** [July 9, 2024, 2:44pm UTC](https://community.influxdata.com/t/time-coming-back-as-epoch-ns-now/34879 "2024-07-09T14:44:15Z")
I am querying an influx3/iox bucket using the influxdb3-java library. In the query result we receive a Stream\ which is basically one object per row with the various columns in the array. When accessing the time… --- ## [Time comparision in Query Performance with and without Measurement Filter in InfluxDB](https://community.influxdata.com/t/time-comparision-in-query-performance-with-and-without-measurement-filter-in-influxdb/34762)
**Author:** [@Satyam](https://community.influxdata.com/u/Satyam)\ **Replies:** 2\ **Last updated:** [June 29, 2024, 5:59am UTC](https://community.influxdata.com/t/time-comparision-in-query-performance-with-and-without-measurement-filter-in-influxdb/34762 "2024-06-29T05:59:48Z")
I have an InfluxDB database with 5 measurements. When I query the data without specifying the measurement filter, I still get the correct data, and the query execution time is the same as when I include the measurement f… --- ## [Telegraf round\_interval option for each input plugin](https://community.influxdata.com/t/telegraf-round-interval-option-for-each-input-plugin/34494)
**Author:** [@SpiderD555](https://community.influxdata.com/u/SpiderD555)\ **Replies:** 2\ **Last updated:** [June 7, 2024, 8:06pm UTC](https://community.influxdata.com/t/telegraf-round-interval-option-for-each-input-plugin/34494 "2024-06-07T20:06:21Z")
Hi, I am trying to time the polling properly with round\_interval (thanks to good blog entry How to Time Your Data Collection with Telegraf Agent Settings | InfluxData), but I miss one information from the docs. Is it ta… --- ## [Aggregate data by shift (7:00 - 7:00)](https://community.influxdata.com/t/aggregate-data-by-shift-7-00-7-00/34284)
**Author:** [@ebabeshko](https://community.influxdata.com/u/ebabeshko)\ **Replies:** 2\ **Last updated:** [May 20, 2024, 2:42pm UTC](https://community.influxdata.com/t/aggregate-data-by-shift-7-00-7-00/34284 "2024-05-20T14:42:49Z")
I need help with the most optimal way to implement queries that aggregate data by shift lasting from 7am yesterday to 7am today. query to get data from beginnig of shift till now. I know about possibilities of date pac… --- ## [Why is the date operation so slow?](https://community.influxdata.com/t/why-is-the-date-operation-so-slow/34255)
**Author:** [@gerhard](https://community.influxdata.com/u/gerhard)\ **Replies:** 2\ **Last updated:** [May 17, 2024, 1:46am UTC](https://community.influxdata.com/t/why-is-the-date-operation-so-slow/34255 "2024-05-17T01:46:15Z")
I want to calculate electricity cost per hour. Because electricity prices vary by hour, I use map and date.hour function to multiply cost by dynamic price. The query below takes 16 seconds: import "date" from(bucket: "… --- ## [Query a between time ( not datetime )](https://community.influxdata.com/t/query-a-between-time-not-datetime/33954)
**Author:** [@Michal\_Augustyniak](https://community.influxdata.com/u/Michal_Augustyniak)\ **Replies:** 8\ **Last updated:** [April 28, 2024, 12:41am UTC](https://community.influxdata.com/t/query-a-between-time-not-datetime/33954 "2024-04-28T00:41:46Z")
Hi I am new here and to flux. I tried even with chatGPT, but nothing worked for me. I have records that value/measurement is a SHIFT number and two tags startTime and endTime which contain hours, for example: startTi… --- ## [Dynamically Selecting Time Ranges in InfluxDB Flux Queries: Error and Solutions](https://community.influxdata.com/t/dynamically-selecting-time-ranges-in-influxdb-flux-queries-error-and-solutions/33794)
**Author:** [@Madhurima\_Rawat](https://community.influxdata.com/u/Madhurima_Rawat)\ **Replies:** 2\ **Last updated:** [April 3, 2024, 5:12pm UTC](https://community.influxdata.com/t/dynamically-selecting-time-ranges-in-influxdb-flux-queries-error-and-solutions/33794 "2024-04-03T17:12:51Z")
I’m using InfluxDB to store time-series data and Flux for querying. I have a scenario where I need to dynamically select start and end times based on specific conditions for each sensor and motif. However, it seems that … --- ## [Flux Windowing Behavior Seems Broken](https://community.influxdata.com/t/flux-windowing-behavior-seems-broken/33512)
**Author:** [@ticchioned](https://community.influxdata.com/u/ticchioned)\ **Replies:** 2\ **Last updated:** [March 11, 2024, 8:17pm UTC](https://community.influxdata.com/t/flux-windowing-behavior-seems-broken/33512 "2024-03-11T20:17:06Z")
Maybe I just don’t understand how Influx windows data, but this behavior doesn’t seem accurate. Can someone explain to me why when i set my windowing period to 13 min, influx windows by 11 min first, then goes to a 13 m… --- ## [Why does the timestamp appear randomly generated when loading data?](https://community.influxdata.com/t/why-does-the-timestamp-appear-randomly-generated-when-loading-data/33208)
**Author:** [@fabreciano](https://community.influxdata.com/u/fabreciano)\ **Replies:** 3\ **Last updated:** [February 15, 2024, 10:44pm UTC](https://community.influxdata.com/t/why-does-the-timestamp-appear-randomly-generated-when-loading-data/33208 "2024-02-15T22:44:16Z")
Hi! I have prepared a CSV with the following data. #datatype measurement,tag,double,double,dateTime:RFC3339 name,building,temperature,humidity,time iot-devices,5a,72.3,34.1,2024-01-01T12:01:00Z iot-devices,5a,72.1,3… --- ## [How can I plot the difference value(now) - value(24h ago) in Flux?](https://community.influxdata.com/t/how-can-i-plot-the-difference-value-now-value-24h-ago-in-flux/22304)
**Author:** [@mihnea17](https://community.influxdata.com/u/mihnea17)\ **Replies:** 5\ **Last updated:** [January 26, 2024, 6:27am UTC](https://community.influxdata.com/t/how-can-i-plot-the-difference-value-now-value-24h-ago-in-flux/22304 "2024-01-26T06:27:24Z")
Hello, I have the following Flux query that plots the value read from a sensor over time: from(bucket: "adeunis") |\> range(start: v.timeRangeStart, stop: v.timeRangeStop) |\> filter(fn: (r) =\> r\["\_measurement"\] == "… --- ## [Writing data to influxdb 2.7.4 using java client library 6.6.0](https://community.influxdata.com/t/writing-data-to-influxdb-2-7-4-using-java-client-library-6-6-0/32773)
**Author:** [@Vikash\_Rai](https://community.influxdata.com/u/Vikash_Rai)\ **Replies:** 1\ **Last updated:** [January 10, 2024, 10:27pm UTC](https://community.influxdata.com/t/writing-data-to-influxdb-2-7-4-using-java-client-library-6-6-0/32773 "2024-01-10T22:27:19Z")
I encountered an issue while attempting to ingest records into InfluxDB 2.7.4 using the Java Client Library version 6.6.0. Despite using a POJO and its corresponding class for data writing, I am unable to successfully in… --- ## [Electricity data emitted from json file in Telegraf](https://community.influxdata.com/t/electricity-data-emitted-from-json-file-in-telegraf/32455)
**Author:** [@dueyfinster](https://community.influxdata.com/u/dueyfinster)\ **Replies:** 1\ **Last updated:** [December 18, 2023, 8:18pm UTC](https://community.influxdata.com/t/electricity-data-emitted-from-json-file-in-telegraf/32455 "2023-12-18T20:18:53Z")
I’m trying to parse the following json data with Telegraf and InfluxDB (both latest docker images) - but I cannot get it to parse the values and the dates to get the correct output. Here’s sample JSON data: \[ { "… --- ## [Output from aggregateWindow and group time does not match row timestamps](https://community.influxdata.com/t/output-from-aggregatewindow-and-group-time-does-not-match-row-timestamps/31801)
**Author:** [@tor](https://community.influxdata.com/u/tor)\ **Replies:** 2\ **Last updated:** [October 16, 2023, 10:52am UTC](https://community.influxdata.com/t/output-from-aggregatewindow-and-group-time-does-not-match-row-timestamps/31801 "2023-10-16T10:52:12Z")
I have data being stored with microsecond precision, but when I aggregate the data it seems to use the timestamp of the batch write rather than the individual rows. This happens when using both flux and InfluxQL. If I g… --- ## [Dynamic calculation or value creation based on a provided value and a time range in hours per day](https://community.influxdata.com/t/dynamic-calculation-or-value-creation-based-on-a-provided-value-and-a-time-range-in-hours-per-day/31506)
**Author:** [@vincent1890](https://community.influxdata.com/u/vincent1890)\ **Replies:** 4\ **Last updated:** [September 25, 2023, 11:03pm UTC](https://community.influxdata.com/t/dynamic-calculation-or-value-creation-based-on-a-provided-value-and-a-time-range-in-hours-per-day/31506 "2023-09-25T23:03:20Z")
Hello, I’m trying to determine if it’s possible to calculate the cost of kilowatt-hours consumed during off-peak hours (€0.1672/KWh) and peak hours (€0.2285/KWh) based on the time period (for example, peak hours from 07… --- ## [Please help - how to obtain current time in the configuration file](https://community.influxdata.com/t/please-help-how-to-obtain-current-time-in-the-configuration-file/30690)
**Author:** [@Jamie\_NG](https://community.influxdata.com/u/Jamie_NG)\ **Replies:** 5\ **Last updated:** [July 28, 2023, 1:32pm UTC](https://community.influxdata.com/t/please-help-how-to-obtain-current-time-in-the-configuration-file/30690 "2023-07-28T13:32:03Z")
Hi, I am new to Influxdb and Telegraf, please help me with this question: In the Telegraf configuration file, I am making a http request with stated start and end time, as below. This is a requirement from the data sou… --- ## [Java Client WriteApi Records 422 Error (points beyond retention policy dropped=1)](https://community.influxdata.com/t/java-client-writeapi-records-422-error-points-beyond-retention-policy-dropped-1/30712)
**Author:** [@25jhs](https://community.influxdata.com/u/25jhs)\ **Replies:** 0\ **Last updated:** [July 14, 2023, 3:59am UTC](https://community.influxdata.com/t/java-client-writeapi-records-422-error-points-beyond-retention-policy-dropped-1/30712 "2023-07-14T03:59:15Z")
Hi I’m the one using influxdb v2.7 Write and read data to InfluxDB in Java. 200 to 300 data are bundled and delivered, and my code is as follows. influxDBClient.getWriteApiBlocking().writePoints(points); Sometimes whi… --- ## [Beim CSV Import werden die -time Werte falsch übernommen](https://community.influxdata.com/t/beim-csv-import-werden-die-time-werte-falsch-ubernommen/29738)
**Author:** [@fluxbt](https://community.influxdata.com/u/fluxbt)\ **Replies:** 3\ **Last updated:** [May 8, 2023, 9:33am UTC](https://community.influxdata.com/t/beim-csv-import-werden-die-time-werte-falsch-ubernommen/29738 "2023-05-08T09:33:26Z")
Beim Import einer CSV-Datei, egal ob in der Influx Oberfläche im Data Explorer oder mit influxql als csv-Datei wird der Wert für \_time falsch übernommen. Die Zeit wird von Satz zu Satz weitergezählt. Mein Inhalt ist voll… --- ## [Different timestamp precision](https://community.influxdata.com/t/different-timestamp-precision/29590)
**Author:** [@LuningAn](https://community.influxdata.com/u/LuningAn)\ **Replies:** 0\ **Last updated:** [April 20, 2023, 9:18am UTC](https://community.influxdata.com/t/different-timestamp-precision/29590 "2023-04-20T09:18:04Z")
I need to save data with a millisecond precision. However, in some cases (rarely) the data need to have a nanosecond precision. Is this possible or will everything need to be in nanoseconds then? Will it affect the stor… --- ## [Query to count values per day](https://community.influxdata.com/t/query-to-count-values-per-day/24498)
**Author:** [@rucaza](https://community.influxdata.com/u/rucaza)\ **Replies:** 2\ **Last updated:** [March 7, 2023, 12:00pm UTC](https://community.influxdata.com/t/query-to-count-values-per-day/24498 "2023-03-07T12:00:45Z")
I created a query that will count the number of occurrences of the Offset field in a range of four days aggregated day by day: from(bucket: "my\_bucket") |\> range(start: -4d, stop: today()) |\> filter(fn: (r) =\> r\[\\"… [Next page](https://community.influxdata.com/tag/time/26.md?match_all_tags=true&page=1&tags%5B%5D=time)