title: Postgresql: Select all data between two dates in playframework 1.x
body: <p>I have a postgresql table with data connected to dates. Each row has data and a date, for example:</p>
  
  <pre>
  2011-02-03    JOHN   Male   etc
  </pre>
  
  <p>I am using playframework. i have created a model named student.java.</p>
  
  <p>and in application.java i have done something like this where firstDate and lastdate are given by user, </p>
  
  <pre><code>List (student studentList) = student.find("timestamp BETWEEN 'firstDate' and 'lastDate'").fetch();
  </code></pre>
  
  <p>i want to fetch all the data present between those two dates.</p>
  
  <p>But i know the query is not correct. Please help me out.</p>
  
  <p>Thanks in advance. :)</p>