title: Cassandra query on timestamp column returns no values with Java's Instant type
body: <p>I'm trying to figure out how I can query cassandra on a minute interval on specific dates with java 8 api.  </p>
  
  <p>For example, imagine I have a groups table.   </p>
  
  <pre><code>create table groups(
  group_name text,
  updated_on timestamp
  primary key (group_name, updated_on)
  );
  </code></pre>
  
  <p>I have the following records inside the table</p>
  
  <pre><code>group_name    updated_on
  RealGroup     2017-01-01 04:30:00-0800
  RealGroup     2017-01-01 04:30:15-0800
  MockGroup     2017-02-05 04:30:00-0800
  </code></pre>
  
  <p>I'd like to execute a query to cassandra like the following.</p>
  
  <pre><code>select * from groups where group_name = 'RealGroup' and updated_on &gt;= 2017 01-01 04:30:00-0800 AND &lt;= 2017-01-01- 04:30:59-0800'
  </code></pre>
  
  <p>So essentially, I'd like to get data ON THE MINUTE interval.</p>
  
  <p>I am using a GroupAccessor with the datastax api.</p>
  
  <pre><code>@Query("SELECT * FROM GROUPS WHERE GROUP_NAME = :groupName AND UPDATED_ON&gt;= :startDate AND UPDATED_ON&lt;= :endDate")
  Result&lt;Group&gt; getResults(@Param("groupName") String groupName, @Param("startDate") Instant startDate, @Param("endDate") Instant endDate);
  </code></pre>
  
  <p>My question is, what would the client call look like?  Whats the correct way to send the request with java 8 api?  </p>
  
  <p>I'm using the following, but it's giving me odd results.</p>
  
  <pre><code>LocalDateTime startDate = LocalDateTime.of(2017, Month.JANUARY, 1, 4, 30);
  LocalDateTime endDate = LocalDateTime.of(2017, Month.JANUARY, 1, 4, 31);
  Instant start = startDate.toInstant(ZoneOffset.UTC);
  Instant end = endDate.toInstant(ZoneOffset.UTC);
  
  Result&lt;Group&gt; dateGroup = groupAccessor.getResults("RealGroup", start, end);
  </code></pre>
  
  <p>So in reality, this code above should return 2 rows.</p>
  
  <pre><code>RealGroup     2017-01-01 04:30:00-0800
  RealGroup     2017-01-01 04:30:15-0800
  </code></pre>
  
  <p>but returns none.</p>