Sounds like you effectively want to be able to do:
select now()-time,poll_resp_time from myseries order by desc limit 1
As far as I know, that’s not possible, as I discovered in this thread: Shift timestamp returned by SELECT query
LATEST RELEASES Real-world AI starts with time series. Time series starts with InfluxDB 3.
Sounds like you effectively want to be able to do:
select now()-time,poll_resp_time from myseries order by desc limit 1
As far as I know, that’s not possible, as I discovered in this thread: Shift timestamp returned by SELECT query
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
|
Calculate elapsed time between start & end of measurement etc
|
0 | 1242 | February 23, 2018 | |
| Time difference between last record and now() | 2 | 1170 | March 21, 2023 | |
| [InfluxQL] Selecting value and time since last value | 2 | 1730 | August 16, 2020 | |
| How to get how much time elapsed since data point is stored in influxdb | 2 | 3232 | August 10, 2020 | |
| Influxdb query last row of all series in a measurement | 5 | 26362 | November 13, 2019 |