WHERE Statement: upper bound on time

[ajetsharwin]

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

[scott]

@ajetsharwin The only explanation I can think of is that the timestamps of your data include smaller fractions of seconds (ms, us, ns). What are the full RFC3339 timestamps in your query results?