title: Trouble with MYSQL query BETWEEN two epoch timestamps?
body: <p>I have epoch timestamps in my mysql database, I am using a Jquery datepicker to choose BETWEEN two dates. It works great when I choose at minimum between 1 day, but if I choose Sunday - Sunday ( the same day ) it should bring back records that have fallen on that day.</p>
  
  <p>I am assuming it is because of the epoch timestamp integrated withing the datepicker.. When you choose a date, like today, it comes back with : </p>
  
  <pre><code>BETWEEN 1317103200 AND 1317103200 ....
  </code></pre>
  
  <p>I know how epoch timestamps work and it seems like it is to the second when you convert and do the math... How do I implement a DISTINT value for that FULL DAY -- so it just looks at the full 24 hours and not down to the millisecond???</p>
  
  <pre><code>SELECT category, id, date, title 
  FROM myTable
  WHERE date BETWEEN $beginDate AND $endDate AND...
  </code></pre>
  
  <p>Thanks so much!!</p>