title: MYSQL query between two timestamps
body: <p>I have the following entry in my DB table</p>
  
  <pre><code>eventName(varchar 100) -&gt; myEvent
  date(timestamp) -&gt; 2013-03-26 09:00:00
  </code></pre>
  
  <p>and I am trying to use the following query;</p>
  
  <pre><code>SELECT * 
  FROM eventList 
  WHERE `date` BETWEEN UNIX_TIMESTAMP(1364256001) AND UNIX_TIMESTAMP(1364342399)
  </code></pre>
  
  <p>i.e between 2013-03-26 00:00:01 and 2013-03-26 23:59:59</p>
  
  <p>but it is giving me 0 results.</p>
  
  <p>I have tried expanding the date range with no luck and there are definitely results within the range.</p>
  
  <p>any help is appreciated.</p>