title: How do I get today items with JPQL
body: <p>I need to get today's items from database (more specifically PostgreSQL) using JPQL.<br>I need all the items that their day is the same as today. I tried this but it is not working because the current timestamp and creation timestamp are not exactly the same due to different times. It does not return any result. <br></p>
  <pre><code>@Query(&quot;select u from User u where u.timestamp = current_timestamp&quot;)
  </code></pre>
  <p>The question is how do I only compare the day?</p>