title: how to select a period of time in mysql?
body: <p>I want to make a MySql selection for a period of time. but i didn't figure it out how to make it correctly.</p>
  
  <p>this is what i tried </p>
  
  <p><code>SELECT * FROM rapoarte WHERE DATE(ziua) BETWEEN 2010-01-12 AND 2011-01-14</code></p>
  
  <p>Can you please help?</p>
  
  <p>thanks,
  Sebastian</p>