# \#date

**URL:** https://community.influxdata.com/tag/date/27.md

[Latest](https://community.influxdata.com/latest.md) · [Categories](https://community.influxdata.com/categories.md) · [Tags](https://community.influxdata.com/tags.md)

---

## [Influxdb 2.1.1 Internal Server Error (Timestamp related)](https://community.influxdata.com/t/influxdb-2-1-1-internal-server-error-timestamp-related/23994)

<div class="topic-metadata">

**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")

</div>

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…

---

## [Why is the date operation so slow?](https://community.influxdata.com/t/why-is-the-date-operation-so-slow/34255)

<div class="topic-metadata">

**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")

</div>

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: "…

---

## [Data in a Measurement](https://community.influxdata.com/t/data-in-a-measurement/32416)

<div class="topic-metadata">

**Author:** [@nicfio](https://community.influxdata.com/u/nicfio)\
**Replies:** 2\
**Last updated:** [December 12, 2023, 7:58am UTC](https://community.influxdata.com/t/data-in-a-measurement/32416 "2023-12-12T07:58:54Z")

</div>

Hello everyone, we have organized a data collection sinking into a influxdb instance. A bucket is a single source with a predefined list of columns. A measurement is a collection of data from the specified bucket: so …

---

## [InfluxDB 2 for arm32v7 release date?](https://community.influxdata.com/t/influxdb-2-for-arm32v7-release-date/20349)

<div class="topic-metadata">

**Author:** [@heath](https://community.influxdata.com/u/heath)\
**Replies:** 6\
**Last updated:** [November 8, 2023, 2:29am UTC](https://community.influxdata.com/t/influxdb-2-for-arm32v7-release-date/20349 "2023-11-08T02:29:57Z")

</div>

:wave:t2: Hey InfluxData community! I’ve used the influxdb 2.0 container a bit, and am hoping to use influxdb 2.0 on some ARM architectures (specifically a raspberry pi for now). Are there plans to build influxdb 2.0 fo…

---

## [Struggling with date format conversion](https://community.influxdata.com/t/struggling-with-date-format-conversion/28785)

<div class="topic-metadata">

**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")

</div>

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") |\> …

---

## [Trying to write stock data to line protocol with date/time and timezone support](https://community.influxdata.com/t/trying-to-write-stock-data-to-line-protocol-with-date-time-and-timezone-support/28002)

<div class="topic-metadata">

**Author:** [@yannisant](https://community.influxdata.com/u/yannisant)\
**Replies:** 1\
**Last updated:** [January 5, 2023, 12:36pm UTC](https://community.influxdata.com/t/trying-to-write-stock-data-to-line-protocol-with-date-time-and-timezone-support/28002 "2023-01-05T12:36:01Z")

</div>

can you please tell me what am I doing wrong here? I’ve been banging my head on the wall with this import yfinance as yf import pandas as pd import influxdb\_client import datetime from datetime import datetime, date fr…

---

## [Cannot import CSVs with unix timestamps](https://community.influxdata.com/t/cannot-import-csvs-with-unix-timestamps/19921)

<div class="topic-metadata">

**Author:** [@vlorian-de](https://community.influxdata.com/u/vlorian-de)\
**Replies:** 2\
**Last updated:** [November 15, 2022, 8:40am UTC](https://community.influxdata.com/t/cannot-import-csvs-with-unix-timestamps/19921 "2022-11-15T08:40:37Z")

</div>

Hi there, I try to migrate a huge collection of measurement data from MySQL to InfluxDB. Therefore measurement data is exported as csv and annotations are added. But when CSV file is imported in InfluxDB, timestamps c…

---

## [Expected RPAREN, got EOF - string literal key AEGN.AT must have a value - invalid expression - unexpected token for property key: ILLEGAL - got unexpected token in string expression](https://community.influxdata.com/t/expected-rparen-got-eof-string-literal-key-aegn-at-must-have-a-value-invalid-expression-unexpected-token-for-property-key-illegal-got-unexpected-token-in-string-expression/26782)

<div class="topic-metadata">

**Author:** [@yannisant](https://community.influxdata.com/u/yannisant)\
**Replies:** 7\
**Last updated:** [September 30, 2022, 7:15am UTC](https://community.influxdata.com/t/expected-rparen-got-eof-string-literal-key-aegn-at-must-have-a-value-invalid-expression-unexpected-token-for-property-key-illegal-got-unexpected-token-in-string-expression/26782 "2022-09-30T07:15:43Z")

</div>

I run into an error. please tell me there is another way of doing this. I need to be able to dynamically select tickers. code: client = InfluxDBClient(url=url, token=token,org=org) query\_api = client.query\_api() tick…

---

## [Custom "Time Format" for graphs -- date only?](https://community.influxdata.com/t/custom-time-format-for-graphs-date-only/25937)

<div class="topic-metadata">

**Author:** [@Patrick808](https://community.influxdata.com/u/Patrick808)\
**Replies:** 2\
**Last updated:** [August 1, 2022, 7:03pm UTC](https://community.influxdata.com/t/custom-time-format-for-graphs-date-only/25937 "2022-08-01T19:03:44Z")

</div>

Is there any way to have graphs in the dashboards display only the two digit date (D) only? The time and year (and to a lesser degree the month) get in the way of providing useful information, as only one stamp shows up…

---

## [InfluxDBv2 Daily Sum Shows Date 1 day ahead](https://community.influxdata.com/t/influxdbv2-daily-sum-shows-date-1-day-ahead/25182)

<div class="topic-metadata">

**Author:** [@Volkan\_Bulbul](https://community.influxdata.com/u/Volkan_Bulbul)\
**Replies:** 0\
**Last updated:** [May 26, 2022, 7:55am UTC](https://community.influxdata.com/t/influxdbv2-daily-sum-shows-date-1-day-ahead/25182 "2022-05-26T07:55:12Z")

</div>

My query is gest daily sums of data. Data sums are correct but date of sums is one day ahead. Todays current sum date 2022-05-26 10:39:35.589, but yesterday also 2022-05-26 00:00:00.000 How can fix it or is that a bug ? …

---

## [Timezone.location issue in OSS 2.2](https://community.influxdata.com/t/timezone-location-issue-in-oss-2-2/25161)

<div class="topic-metadata">

**Author:** [@kristofff](https://community.influxdata.com/u/kristofff)\
**Replies:** 0\
**Last updated:** [May 24, 2022, 7:55pm UTC](https://community.influxdata.com/t/timezone-location-issue-in-oss-2-2/25161 "2022-05-24T19:55:13Z")

</div>

I’m having some difficulty with the timezone.location option, and hoping someone can help me figure out what I’m doing. In a nutshell, I get the same results regardless of the timezone options I set, or even if I don’t s…

---

## [Influx 2.0.5 vs. 2.1.1 Performance Issue](https://community.influxdata.com/t/influx-2-0-5-vs-2-1-1-performance-issue/23822)

<div class="topic-metadata">

**Author:** [@ticchioned](https://community.influxdata.com/u/ticchioned)\
**Replies:** 0\
**Last updated:** [February 11, 2022, 4:48pm UTC](https://community.influxdata.com/t/influx-2-0-5-vs-2-1-1-performance-issue/23822 "2022-02-11T16:48:15Z")

</div>

I have two instances of Influx DB running, one is version 2.0.5, and the other is 2.1.1. I noticed a performance issue with 2.1.1 that I have not been able to replicate on version 2.0.5. I have the same data being read…

---

## [Exlude specific weekdays (e.g. weekend) from Flux query](https://community.influxdata.com/t/exlude-specific-weekdays-e-g-weekend-from-flux-query/22805)

<div class="topic-metadata">

**Author:** [@emil](https://community.influxdata.com/u/emil)\
**Replies:** 5\
**Last updated:** [December 7, 2021, 4:38pm UTC](https://community.influxdata.com/t/exlude-specific-weekdays-e-g-weekend-from-flux-query/22805 "2021-12-07T16:38:29Z")

</div>

Is it possible to exclude specific weekdays from a Flux query? Example: I am querying the last 4 week but don’t want all data with timestamp on Saturdays and Sundays I know this possible with SQL, see: StackOverflow I…

---

## [Daily Agreggation in local Timezone](https://community.influxdata.com/t/daily-agreggation-in-local-timezone/22794)

<div class="topic-metadata">

**Author:** [@jimmym](https://community.influxdata.com/u/jimmym)\
**Replies:** 5\
**Last updated:** [December 3, 2021, 6:03pm UTC](https://community.influxdata.com/t/daily-agreggation-in-local-timezone/22794 "2021-12-03T18:03:13Z")

</div>

I am attempting to aggregate data on a daily basis in the specific timezone of the customer. My goal is to create a single record with a time of midnight for each function (mean, min, max, etc) for the selected day, and …

---

## [How does it show data on day of week?](https://community.influxdata.com/t/how-does-it-show-data-on-day-of-week/21284)

<div class="topic-metadata">

**Author:** [@mm0001](https://community.influxdata.com/u/mm0001)\
**Replies:** 6\
**Last updated:** [August 24, 2021, 11:47pm UTC](https://community.influxdata.com/t/how-does-it-show-data-on-day-of-week/21284 "2021-08-24T23:47:38Z")

</div>

Hi, I would like to pick up data on every Friday. for example; 2021/7/2, 2021/7/9, 2021/7/16, 2021/7/23, 2021/7/30 I tried below query, but it does not work. How do I write query? import “date” from(bucket: “my\_b…

---

## [Telegraf csv\_timestamp\_format to parse a time step](https://community.influxdata.com/t/telegraf-csv-timestamp-format-to-parse-a-time-step/16638)

<div class="topic-metadata">

**Author:** [@frank0434](https://community.influxdata.com/u/frank0434)\
**Replies:** 2\
**Last updated:** [July 8, 2021, 6:30pm UTC](https://community.influxdata.com/t/telegraf-csv-timestamp-format-to-parse-a-time-step/16638 "2021-07-08T18:30:08Z")

</div>

Hello all, New to telegraf and influxdb. Followed a very useful tutorial posted by @Anaisdg and managed to reproduce it. Now I’d like to try telegraf on my own data. But struggle to understand the timestamp\_format bi…

---

## [Daily aggregation (by date not 24h) and range (first to last record)](https://community.influxdata.com/t/daily-aggregation-by-date-not-24h-and-range-first-to-last-record/20282)

<div class="topic-metadata">

**Author:** [@t481](https://community.influxdata.com/u/t481)\
**Replies:** 1\
**Last updated:** [June 8, 2021, 4:19pm UTC](https://community.influxdata.com/t/daily-aggregation-by-date-not-24h-and-range-first-to-last-record/20282 "2021-06-08T16:19:56Z")

</div>

Hello, Please could someone assist me with how to specify the range so that it would start from the oldest to the last record in the bucket instead of the v.timeRangeStart and v.timeRangeStop |\> range(start: v.timeRang…

---

## [Query Group by time ( Shift time)](https://community.influxdata.com/t/query-group-by-time-shift-time/18698)

<div class="topic-metadata">

**Author:** [@Karan12592](https://community.influxdata.com/u/Karan12592)\
**Replies:** 2\
**Last updated:** [March 27, 2021, 5:59am UTC](https://community.influxdata.com/t/query-group-by-time-shift-time/18698 "2021-03-27T05:59:04Z")

</div>

Hi, I want to query the database Group by time ( default shift time ) SELECT (Max(“field1”)) FROM " Measurement1" WHERE (“id” = ‘01’) AND $timeFilter GROUP BY time (Shift time) fill (null) Example: Shift time 1: 9:00…

---

## [Can i using rfc3339 format when i insert data?](https://community.influxdata.com/t/can-i-using-rfc3339-format-when-i-insert-data/15979)

<div class="topic-metadata">

**Author:** [@cybang](https://community.influxdata.com/u/cybang)\
**Replies:** 2\
**Last updated:** [September 15, 2020, 11:13pm UTC](https://community.influxdata.com/t/can-i-using-rfc3339-format-when-i-insert-data/15979 "2020-09-15T23:13:35Z")

</div>

hi… :joy: The content is the same as the title… Can i using rfc3339 format when i insert data? If possible, what is my problem? Please let me know…!! :cry:

---

## [How to change influxDB system time?](https://community.influxdata.com/t/how-to-change-influxdb-system-time/15644)

<div class="topic-metadata">

**Author:** [@abcd\_shri](https://community.influxdata.com/u/abcd_shri)\
**Replies:** 3\
**Last updated:** [August 20, 2020, 7:04pm UTC](https://community.influxdata.com/t/how-to-change-influxdb-system-time/15644 "2020-08-20T19:04:50Z")

</div>

Using the below command I am able to get the influxDB current time. But can anyone please tell me how to reset this time? SHOW DIAGNOSTICS \`\`\`\`\`\`\`\`\`\`\`\`\`\`\`\`\`\` PID currentTime started …

---

## [Create a new \_time column from a short date column stored as string](https://community.influxdata.com/t/create-a-new-time-column-from-a-short-date-column-stored-as-string/13834)

<div class="topic-metadata">

**Author:** [@aastroem](https://community.influxdata.com/u/aastroem)\
**Replies:** 1\
**Last updated:** [May 6, 2020, 9:23pm UTC](https://community.influxdata.com/t/create-a-new-time-column-from-a-short-date-column-stored-as-string/13834 "2020-05-06T21:23:25Z")

</div>

Hi there, I’ve got a point in time dataset including information about how many online shopping slots (count) that are available for different stores (chain, name) per date (YYYY-mm-dd). I would like to make a bar char…

---

## [Telegraf ignoring seconds precision and inserts wrong timestamp](https://community.influxdata.com/t/telegraf-ignoring-seconds-precision-and-inserts-wrong-timestamp/11237)

<div class="topic-metadata">

**Author:** [@Yogesh](https://community.influxdata.com/u/Yogesh)\
**Replies:** 2\
**Last updated:** [September 14, 2019, 4:45am UTC](https://community.influxdata.com/t/telegraf-ignoring-seconds-precision-and-inserts-wrong-timestamp/11237 "2019-09-14T04:45:53Z")

</div>

Using telegraf with http\_listener\_v2 plugin for input and influxdb plugin for output. Posting data in line control format and timestamp with seconds precision. This data is getting inserted to influxdb with wrong timest…

---

## [From Laravel to Chronograph Log Viewer - Date Parsing Issue](https://community.influxdata.com/t/from-laravel-to-chronograph-log-viewer-date-parsing-issue/8981)

<div class="topic-metadata">

**Author:** [@ppataki](https://community.influxdata.com/u/ppataki)\
**Replies:** 4\
**Last updated:** [March 13, 2019, 9:21am UTC](https://community.influxdata.com/t/from-laravel-to-chronograph-log-viewer-date-parsing-issue/8981 "2019-03-13T09:21:43Z")

</div>

Hello there, I’m trying to use the Log Viewer from Chronograph to view my custom app logs. I’m aware that the datas sent to InfluxDb needs to be in syslog format to be shown in the UI. The logs are written in a specif…

---

## [240h retention policy but no data is dropped](https://community.influxdata.com/t/240h-retention-policy-but-no-data-is-dropped/6807)

<div class="topic-metadata">

**Author:** [@laimaretto](https://community.influxdata.com/u/laimaretto)\
**Replies:** 0\
**Last updated:** [September 28, 2018, 4:31pm UTC](https://community.influxdata.com/t/240h-retention-policy-but-no-data-is-dropped/6807 "2018-09-28T16:31:10Z")

</div>

SO I have modified the autogen retention policy to 240h and a 1h shard-group-duration. show retention policies name duration shardGroupDuration replicaN default ---- -------- ------------------ -------- ------- au…

---

## [Multiple variables in one field](https://community.influxdata.com/t/multiple-variables-in-one-field/5047)

<div class="topic-metadata">

**Author:** [@szerwi](https://community.influxdata.com/u/szerwi)\
**Replies:** 5\
**Last updated:** [June 1, 2018, 4:55pm UTC](https://community.influxdata.com/t/multiple-variables-in-one-field/5047 "2018-06-01T16:55:26Z")

</div>

Hi, Is it possible to store many variables in one field, so there will be only one timestamp? Or there must be only one variable in one field? I’m sending 2 floats per 10 seconds to database and I have 8GB SD card so I…

---

## [How to test against current day/month/year?](https://community.influxdata.com/t/how-to-test-against-current-day-month-year/3838)

<div class="topic-metadata">

**Author:** [@jbguillois](https://community.influxdata.com/u/jbguillois)\
**Replies:** 3\
**Last updated:** [February 8, 2018, 5:07pm UTC](https://community.influxdata.com/t/how-to-test-against-current-day-month-year/3838 "2018-02-08T17:07:21Z")

</div>

Hello, I am using Influx & Kapacitor to process data coming from various applications. Each application sends an event (a ‘subscription’) as soon as a business user performs an action with this application. Each hour fo…

---

## [Infer day of the week from InfluxDB time-stamp](https://community.influxdata.com/t/infer-day-of-the-week-from-influxdb-time-stamp/3466)

<div class="topic-metadata">

**Author:** [@saba](https://community.influxdata.com/u/saba)\
**Replies:** 2\
**Last updated:** [January 24, 2018, 1:31am UTC](https://community.influxdata.com/t/infer-day-of-the-week-from-influxdb-time-stamp/3466 "2018-01-24T01:31:06Z")

</div>

Hi, A very basic question. I’m using a SELECT query to get some traffic utilization for a device ‘abcd’ for Nov, 2017: influx -execute “SELECT time, value FROM util\_db WHERE hostname=‘abcd’ AND time \>= ‘2017-11-01T00:…

---

## [How to post CSV file data into the InfluxDB server in same time series as CSV File's time series?](https://community.influxdata.com/t/how-to-post-csv-file-data-into-the-influxdb-server-in-same-time-series-as-csv-files-time-series/3638)

<div class="topic-metadata">

**Author:** [@Prayuktibid](https://community.influxdata.com/u/Prayuktibid)\
**Replies:** 2\
**Last updated:** [January 10, 2018, 11:48pm UTC](https://community.influxdata.com/t/how-to-post-csv-file-data-into-the-influxdb-server-in-same-time-series-as-csv-files-time-series/3638 "2018-01-10T23:48:08Z")

</div>

I would like to post data from a CSV file to InfluxDB file and the Time column of InfluxDB should match with CSV file Time column. I meant InfluxDB time series should same as CSV file’s Time series. My main motive is In…

---

## [Cannot insert int values after specific date](https://community.influxdata.com/t/cannot-insert-int-values-after-specific-date/2935)

<div class="topic-metadata">

**Author:** [@Dragomir\_Mashov](https://community.influxdata.com/u/Dragomir_Mashov)\
**Replies:** 1\
**Last updated:** [November 2, 2017, 1:36pm UTC](https://community.influxdata.com/t/cannot-insert-int-values-after-specific-date/2935 "2017-11-02T13:36:07Z")

</div>

Hi, I am running several InfluxDB servers and on some of them it is no longer possible to insert INT values. The problem appears to be happening before or after 30.10.2017 00:00:00 UTC. On one of the servers everything …

---

## [Retention policy not working?](https://community.influxdata.com/t/retention-policy-not-working/2393)

<div class="topic-metadata">

**Author:** [@TDeoodfig](https://community.influxdata.com/u/TDeoodfig)\
**Replies:** 1\
**Last updated:** [September 20, 2017, 5:35pm UTC](https://community.influxdata.com/t/retention-policy-not-working/2393 "2017-09-20T17:35:19Z")

</div>

Hi, I’m new to influxDB and running into some problem. I made a retention policy for one week but it’s keep data that’s older than a week. Here’s a screen shot. How does retention policy work? is this because I put the …

[Next page](https://community.influxdata.com/tag/date/27.md?match_all_tags=true&page=1&tags%5B%5D=date)
