- **InfluxDB version: InfluxDB shell version: 1.8.2** - **InfluxDB-python version: 5.3.1** - **Python version: Python 3.8.10** - **Operating system version: Ubuntu 20.04** Write in your influxdb at least 2 datapoint: time value '2022-07-28 08:59:59.818000' any '2022-07-28 09:00:00.000000' any and perform the following quary using thos exat timestamp: ``` bind_params = { 'timeFrom_': timeFrom_.strftime("%Y-%m-%d %H:%M:%S.%f"), 'timeTo': timeTo.strftime("%Y-%m-%d %H:%M:%S.%f") } df = pd.DataFrame(client.query(f"SELECT * from {retention_policy}.{meas_name} WHERE time > $timeFrom_ and time <= $timeTo limit 86400;", bind_params=bind_params).get_points()) ``` The query return a Dataframe of one row with timestamp 2022-07-28 08:59:59.818000 The expected behavior is to get an empty dataframe since **the query uses > timeForm and not >= timeFrom**
Write in your influxdb at least 2 datapoint:
time value
'2022-07-28 08:59:59.818000' any
'2022-07-28 09:00:00.000000' any
and perform the following quary using thos exat timestamp:
The query return a Dataframe of one row with timestamp 2022-07-28 08:59:59.818000
The expected behavior is to get an empty dataframe since the query uses > timeForm and not >= timeFrom