title: mysql returned empty result set even records are existing
body: <p>My query:    </p>
  
  <pre><code>SELECT COUNT( bilno ) 
  FROM trans_master
  WHERE dt
  BETWEEN 25-10-2017
  AND 03-11-2017
  AND refid=1
  </code></pre>
  
  <p>Below is table (trans_master): </p>
  
  <p><a href="https://i.stack.imgur.com/WVz26.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/WVz26.jpg" alt="enter image description here"></a></p>