Query a single time point

InfluxDB 2
, ,
1

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 an absolute time
myTimeStamp = 2024-09-12T20:01:13Z

This will work but the query takes too long and is canceled by the system:
…+ $" |> range(start: {myTimeStamp}, stop: now())" + …

This generates an error because it’s not seen as a range:
…+ $" |> range(start: {myTimeStamp}, stop: {myTimeStamp})" + …

Adding a r._time condition to the filter returns an empty result because that equality is always false it seems:
…+ $" |> range(start: {myTimeStamp}, stop: now())" + …
…+ $" filter(fn: (r) => … r._time == {myTimeStamp} …)" + …

Obtaining the timestamps as a string and using time(v: timeStampString) produces the same results.

What can I do to query a single time point?

Thanks.

2

How often is your data updated? I.e. which timestamp would be next to your {myTimeStamp}?

What about trying

 |> range(start: 2024-09-12T20:01:13Z, stop: 2024-09-12T20:01:14Z)

or

import "date"
...
  |> range(start: 2024-09-12T20:01:13Z, stop: date.add(d: 1s, to: 2024-09-12T20:01:13Z))

or

import "date"
...
  |> range(start: {myTimeStamp}, stop: date.add(d: 1s, to: {myTimeStamp}))