title: how to get date between two dates in mysql?
body: <p>In MySql database have <code>AM_TIMETABLE</code> table in that </p>
  
  <pre><code>UserId        DateTime
   101        2012-08-08 04:00:00 
   102        2012-08-15 10:00:00
   103        2012-08-18 09:00:00
   104        2012-08-24 05:00:00
  </code></pre>
  
  <p>My Question is, i'm passing start-date and end-date then i'll get <code>DateTime</code> column date
  for ex:</p>
  
  <pre><code>select * from AM_TIMETABLE where DateTime&lt;='2012-08-08 00:00:00' and DateTime&gt;='2012-08-20 00:00:00'
  </code></pre>
  
  <p>then i will get 101,102,103 UserId's value.
  but i'm getting error <code>please help</code></p>