title: convert and filter datetime with mysql
body: <p>Iam struggling to get all dates from now (all dates from today or the future).</p>
  
  <p>Unfortunately my dates are in this format: '%d%m%Y %H:i' (08.06.2013 12:00)</p>
  
  <p>I tried a couple of things, the last was:</p>
  
  <pre><code>SELECT * FROM `events` WHERE DATE_FORMAT(SUBSTRING(enddate,1,9),'%Y%m%d') &gt;= DATE_FORMAT(CURDATE(),'%Y%m%d')
  </code></pre>
  
  <p>I thought this would convert into: (when date = 27.08.2013)</p>
  
  <pre><code>SELECT * FROM `events` WHERE 20130827 &gt;= 20130608
  </code></pre>
  
  <p>But its now working... I get too much results :-/</p>
  
  <p>Any help would be appreciated...</p>
  
  <p>Thanks!</p>