title: MySQL compare unix timestamps
body: <p>I'm trying to get all records which have a <code>date_created</code> within 2 hours ago. It's a unix timestamp which is created from the php function <code>time()</code>. Here is my current query:</p>
  
  <pre><code>SELECT id from gsapi_synsets where name = "Beyonce" and date_created BETWEEN  UNIX_TIMESTAMP(date_created) and UNIX_TIMESTAMP(DATE_ADD(CURDATE(),INTERVAL 2 hour))    
  </code></pre>
  
  <p>Doesn't seem to be working though. </p>