title: Codeigniter: Compare a MySql Datetime with Current Date
body: <p>I need to compare a MySQL datetime with the current time, to get the dateDiff to show a messange if the MySQL datetime, is less than 30 days from today.</p>
  
  <p>I'm using codeigniter, and I tried a lot of helpers, and lots of thing, I just can't get to work.</p>
  
  <p>Some people says that is better to save in database a timespan, I just don't know wich one is the best aproach.</p>
  
  <p>Thanks in advance!</p>
  
  <p><strong>EDIT:</strong> I'm looking for a CI code, or a Mysql Code, or both, to get it to work. It doesn't matter where i get the current date (could be mysql or server time).
  Also, I have the needed code on the view, and the controller, I just need some model code to get it, or MySql code</p>