title: Mysql between query not working
body: <p>I am using mysql. I want to display records between two dates.
  I searched through web and found that mysql's date format is yyyy/mm/dd.
  so I am writing query as follows,</p>
  
  <pre><code>select 
      * 
  from tbl_reservation 
  where 
      current_date between '2014-03-28' and '2014-03-26';
  </code></pre>
  
  <p>But, I don't know why it is not working. "col_date" has DATE datatype. I am not storing time in it.</p>
  
  <p>Let me give you some idea what i have done at back end,</p>
  
  <pre><code>SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
  Date curr_date=new Date();
  String compareDate=sdf.format(curr_date);
  </code></pre>
  
  <p>And I am storing this value in "col_date". Is it happening because of this processing?</p>
  
  <p>Thanks for your valuable time in advance.</p>