title: Fastest way to compare dates: UNIX_TIMESTAMP or FROM_UNIXTIME or string
body: <p>What is the fastest way to select rows with a field greater than a certain date?</p>
  
  <pre><code>WHERE date &gt; FROM_UNIXTIME(12345)
  </code></pre>
  
  <p>or</p>
  
  <pre><code>WHERE UNIX_TIMESTAMP(date) &gt; 12345
  </code></pre>
  
  <p>or</p>
  
  <pre><code>WHERE date &gt; '2011-05-01 09:00:00'
  </code></pre>