title: Mysql select between two dates won't work
body: <p>I want to SELECT row BETWEEN two dates(date1 and date2) from table. I have experienced this problem but I don't know why it won't work this time. I only have 1 row in my receipt table with timestamp : 2015-05-29 22:09:44.
  And I have tried these syntaxs:</p>
  
  <pre><code>SELECT * FROM receipt
  WHERE (date BETWEEN 2015-05-22
  AND 2015-05-30) //not work even with date_format()
  
  SELECT * FROM receipt
  WHERE date &gt; 22-05-2015 AND date &lt; 30-05-2015 //not work even with date_format()
  
  SELECT * FROM receipt
  WHERE date &gt; 22-05-2015 //work but when I changed to date &gt; 22-07-2015 it's still select row (my timestamp is may 2015)
  </code></pre>