In InfluxDB, I aim to retrieve data within the range of 00:00:00 to 23:59:59 every day

InfluxDB 2
1

from(bucket: “power_data”)
|> range(start: -1d, stop: now()) <— is not 00:00:00 to 23:59:00
|> filter(fn: (r) => r[“_measurement”] == “summary”)

Thank you.

2

Hi @Tachapong_Phantarak

Does this work?

|> range(start: today())
3

not work
result is 2024-01-08 07:02:07 - 2024-01-08 08:27:08

i use this
range(start: today(),stop: now())
2024-01-08 07:02:07 - 2024-01-08 08:32:07

not work i need 2024-01-08 00:00:00 - 2024-01-08 23:59:00 my time zone +7 thailand

please