title: Now in UNIX time
body: <p>I have changed the date field I am using in one of my sites. The new field appears to store the dates in UNIX time format.</p>
  
  <p>I was using this:</p>
  
  <pre><code>AND matrix.col_id_3 &gt; (DATE_FORMAT(NOW(), '%Y%m%d'))
  </code></pre>
  
  <p>to check if the date stored in matrix.col_id_3 was more than todays date.</p>
  
  <p>How can I do this with the UNIX time format?</p>
  
  <p>The dates look like this: 1412736180</p>