title: JPQL get difference in days between a column and now
body: <p>I'm using hibernate and jpa in a spring boot application.
  I have a hibernate entity with 2 columns, <code>type</code> (string) and <code>date</code> (LocalDate). </p>
  
  <p>I want to select all the columns and the difference of days between my date column and now. </p>
  
  <p>I succeeded in PostgreSQL: <code>select date, date - current date from table;</code></p>
  
  <p>I'm using an interface which extends JpaRepository. Until now i was successfully to insert new queries through <code>@Query</code> annotations. 
  I can't figure it out how to select my columns and a column containing the difference of days in jpql.</p>
  
  <p>Kind regards,</p>