title: Select Query with "less than" requirement doesn't work in InfluxDB Query Language
body: <p>I use influxdb 1.7.9-1 with some databases and some measurements. Now i want to select datapoints in a specific time range from a measurement with filters for fields and one filter for a tag. The timerange is from 2022-01-31T00:00:01.129322Z to 2022-01-31T23:59:54.693945Z</p>
  <pre><code>SELECT &quot;test_field&quot; FROM &quot;test_measurement&quot; WHERE (&quot;tag_1&quot; = '165' AND &quot;tag_2&quot; = 'State' AND &quot;tag_3&quot; = 'I' AND time &gt;= '2022-01-31T00:00:00.0Z')
  </code></pre>
  <p>This query is giving me all datapoints between 2022-01-31T00:00:01.129322Z and 2022-01-31T23:59:54.693945Z</p>
  <p>Now I want all datapoints between 2022-01-31T00:00:00.00Z and 2022-01-31T01:00:00.0Z</p>
  <p>I try it like this:</p>
  <pre><code>SELECT &quot;test_field&quot; FROM &quot;test_measurement&quot; WHERE (&quot;tag_1&quot; = '165' AND &quot;tag_2&quot; = 'State' AND &quot;tag_3&quot; = 'I' AND time &gt;= '2022-01-31T00:00:00.0Z' AND time &lt;= '2022-01-31T01:00:00.0Z')
  </code></pre>
  <p>But this query doesn't  work.</p>
  <p>Is anybody out there who can tell me why?</p>
  <p>Or is there another way to query a certain period of time from a database?</p>
  <p>UPDATE 2022-03-22:
  I found something interesting.</p>
  <p>I connected the InfluxDB with Grafana.
  At the picture below you can see my data with Timerange 2022-01-31 00:00:00 to 2022-02-22 00:00:00. This query also works at the CLI.</p>
  <p><a href="https://i.stack.imgur.com/QxTKG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QxTKG.png" alt="Grafana1" /></a></p>
  <p>But then i changed the time range for one day in an suddendly i have no data. Timerange 2022-01-31 00:00:00 to 2022-02-22 00:00:00. Grafana gives me no query, but i changed the time range from query before but there a no datapoints in the CLI.</p>
  <p><a href="https://i.stack.imgur.com/Hz9aF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Hz9aF.png" alt="Grafana2" /></a></p>
  <p>Is there any setting which i can change in Grafana or InfluxDB that i can see my data in a closer timerange?</p>