title: Get mysql rows where date timestamp is 30 days or newer
body: <p>I am trying to get a bunch of mysql rows from the last 30 days using this sql:</p>
  
  <pre><code>SELECT * FROM `articles` WHERE date &gt;= DATE(NOW() - INTERVAL 30 DAY) ORDER BY `views` DESC
  </code></pre>
  
  <p>I am obviously doing something wrong as this returns rows from last year.</p>
  
  <p>My date field in a gmt timestamp.</p>