title: Select Rows Between Start and End Column (Unix timestamps)
body: <p>I'm trying to write a query that takes a Unix Timestamp (i.e. 1396396810 = 4/1/2014 6:00:10 PM) and check a table to see if that date falls between the <code>start</code> and <code>end</code> columns.</p>
  
  <p>1396332000 = 4/1/2014 12:00:00 AM </p>
  
  <p>1396504800 = 4/3/2014 12:00:00 AM</p>
  
  <p>I have table <code>deposit_dates</code></p>
  
  <pre><code>id | start | end | status
  --------------------------
  1  | 1396332000 | 1396504800 | 1
  </code></pre>
  
  <p>And I have a query</p>
  
  <pre><code>SELECT * FROM deposit_dates
  WHERE start &gt;= 1396396810
  AND end &lt;= 1396396810;
  </code></pre>
  
  <p>My problem is that the query returns 0 rows, when <code>1396396810</code> is between <code>1396332000</code> and <code>1396504800</code>.</p>
  
  <p>Thank you in advance!</p>