title: Select data between a date/time range
body: <p>How do I select data between a date range in MySQL. My <code>datetime</code> column is in 24-hour zulu time format. </p>
  
  <pre><code>select * from hockey_stats 
  where game_date between '11/3/2012 00:00:00' and '11/5/2012 23:59:00' 
  order by game_date desc;
  </code></pre>
  
  <p>Returns nothing despite having data between these time periods. Do I have to force the values in the <em>'from'</em> and <em>'to'</em> fields to <code>datetime</code> type in the query?</p>