title: SQL Time passed since
body: <p>I searched, and I tried the examples, but every script is incorrect!</p>
  
  <h2>Here's the script I'm using just for testing</h2>
  
  <pre><code>mysql_query("Delete FROM ScannedIDs WHERE 'datetime' &gt;= (NOW() + INTERVAL 1 DAY)") or 
  die(mysql_error());
  
  $sql = mysql_query("Select * FROM ScannedIDs WHERE 'datetime' &gt;= (NOW() + INTERVAL 1 DAY)") or 
  die(mysql_error());
  
  $rows = mysql_num_rows($sql);
  echo "Found $rows results!";
  </code></pre>
  
  <hr>
  
  <p>Here's the MYSQL data</p>
  
  <pre><code>                                        steamid             datetime
  Edit Edit   Copy Copy   Delete Delete   76561198035301803   2015-01-06 01:40:06
  Edit Edit   Copy Copy   Delete Delete   76561197984607788   2015-01-06 01:40:06
  Edit Edit   Copy Copy   Delete Delete   76561197965902616   2015-01-06 01:40:06
  Edit Edit   Copy Copy   Delete Delete   76561198043885314   2015-01-06 01:40:06
  Edit Edit   Copy Copy   Delete Delete   76561198040227469   2015-01-06 01:40:06
  Edit Edit   Copy Copy   Delete Delete   76561198054594853   2015-01-06 01:40:06
  Edit Edit   Copy Copy   Delete Delete   76561198008404239   2015-01-06 01:40:06
  Edit Edit   Copy Copy   Delete Delete   76561198021278627   2015-01-06 01:40:06
  </code></pre>
  
  <hr>
  
  <p>At this time, it's the same exact date, it should return 0 results!
  24 hours from now, it's susposed to return 8 results.</p>
  
  <p>I don't understand why it's returning 8 results, when a day did not pass by yet!</p>