Hey Team,
I’m using
DB: InfluxDB 2.7
Language: InfluxQL
Question: Why doesn’t influx return the last datapoint as 2023-03-31T16:00:00Z
as per the where statement in the query below? It’s for some reason returning 2023-03-31T15:59:00Z
SELECT "quantity"
FROM "inventory_management".."group-products"
WHERE time >= '2023-03-30T15:00:00Z' AND "time" <= '2023-03-31T16:00:00Z' and product_id = 'YAZOO'
GROUP BY "product_id"
cc: @Anaisdg , @Jay_Clifford , @scott this could be a quick one, tagging for attention please