title: I Want to get a week value
body: <p>I wan to get the value of only one week. I am using the following JPA query:</p>
  
  <pre><code> SELECT a 
   FROM questions.dao.hibernate.Questions a 
   WHERE (a.posted_date-CURRENT_DATE)&gt;= 7
  </code></pre>
  
  <p>But I am getting an error message like</p>
  
  <pre><code>org.hibernate.QueryException: could not resolve property: posted_date of: questions.dao.hibernate.Questions [SELECT a FROM questions.dao.hibernate.Questions a WHERE (a.posted_date-CURRENT_DATE)&gt;=7]
  </code></pre>
  
  <p>Please help me.</p>
  
  <p>Thanks </p>