title: Getting values in between ordinary date and timestamp from mysql database
body: <p>I have a standard mysql timestamp in this format 2011-11-14 20:06:24 . This timestamp will be added whenever a new record is added to the table with the name lead. </p>
  
  <p>I have two input fields for the user to enter from date and to date in dd/mm/yyyy format. Once the user enters both dates and press a button the values will be passsed to other field to get the records from the table lead which are inserted between the time range.</p>
  
  <p>I tried the below query but its not working</p>
  
  <pre><code>SELECT  DATE_FORMAT(added_on, '%d/%m/%Y') as date
  FROM    lead
  WHERE   added_on BETWEEN "10/11/2011" AND "14/11/2011"
  </code></pre>