title: @Query for selecting date from datetime
body: <p>I have a JPA mapped &quot;event&quot; object that includes a timestamp column.  I am trying to select all events that occurred on a specific date.  To do this I need to ignore the time component of the timestamp.  I am not sure that this is possible using non database specific functions?  Something like this fails to select:</p>
  <pre><code>@Query(&quot;SELECT r FROM BioChemRequest r WHERE r.pasId = :pasid AND r.observationDate BETWEEN :startDate AND :startDate&quot;)
  public List &lt;BioChemRequest&gt; find(@Param(&quot;pasid&quot;) String pasid , @Param(&quot;startDate&quot;) Date startDate);
  </code></pre>