title: searching data between dates stored in varchar in mysql
body: <p>I am storing my dates in column server_date_time in <code>varchar</code> in <code>dd/mm/yyyy</code> format and i want to fetch the records lying between some dates so i have used the query</p>
  
  <pre><code>    select * from activity_emp 
  where date_format(str_to_date(substr(server_date_time,1,10),'%d/%m/%Y'),'%d/%m/%Y')&gt;=
  '29/09/2012'
      and date_format(str_to_date(substr(server_date_time,1,10),'%d/%m/%Y'),'%d/%m/%Y')&lt;=
  '07/10/2012';
  </code></pre>
  
  <p>I have converted <code>varchar</code> to string in query but my query return query data only related to 29/09/2012 and 30/09/2012. It should also return query for the month of October</p>