title: select timestamp older than
body: <p>How i can select from database the items older than 12 hours?!
  I using a timestamp column to store the time but I don't think i need year,month,day only hours
  I have something  like this but it dosen't work (no error just returning all data from table)</p>
  
  <pre><code>$sql = "SELECT *FROM Y WHERE X and time &gt; now() - INTERVAL 12 HOUR";
  </code></pre>
  
  <hr>
  
  <p>Type :      timestamp</p>
  
  <p>You're right Salman A .Thanks</p>