Relative Content

Tag Archive for influxdb

Influxdb query to select last datapoint each day

I have a timeseries in InfluxDB which contains the energy (kWh) used and it resets every day at midnight. I would like to get energy consumption (kWh) for each day. No interpolation, mean values etc.

restore influxdb database without backup

I had an influxdb (v1.8) server running properly for 2,5 years on a raspberry pi 4, with an SSD.
Unfortunately, after a power cut my raspberry do not start anymore.

How can I format the timestamp output from my InfluxQL query to RFC3339

I have a bit of a conundrum, we are using InfluxData’s InfluxDB Cloud (hosted on AWS). It is my understanding that querying a database using the API should by default return any timestamps in RFC3339 format, however all my timestamps are returned in unix format. As we are on InfluxDB Cloud, we do not have access to the CLI to force the database to a particular precision. How can a switch my database to returning results in human readable date format, to millisecond precision.