title: mysql between operator with dates
body: <pre><code>select '2011-02-29' BETWEEN '2011-02-01' AND '2011-03-03'‎
  </code></pre>
  
  <p>this is returning 1. I think <strong>between</strong> doesn't consider leap year. I want your view on this?</p>
  
  <p><strong>[EDIT]</strong><br>
  <code>SELECT DATE( '2010-04-31' )</code> is returning NULL;<br>
  But <code>select str_to_date('2010-04-31', '%Y-%m-%d')</code> is retuning date. </p>
  
  <p>Why?</p>
  
  <p>Thanks
  Venu</p>