title: Date Datatype working other datatype not working Sql
body: <p>When I select using <code>date</code> format it is working e.g:</p>
  
  <pre><code>select * 
  from driverdetails 
  where licenserenewaldate between '2015-01-27' and '2015-02-27'
  </code></pre>
  
  <p>When I'm using <code>varchar</code> or <code>text</code> <code>(27-01-2015)</code>, it is not retrieving.</p>
  
  <pre><code>select * 
  from driverdetails 
  where licenserenewaldate between '27-01-2015' and '27-02-2015'
  </code></pre>
  
  <p>It is not working. It's showing empty value.</p>