title: Timediff in MySQL wrong values
body: <p>I need some help with my PHP script.
  I have a MySQL database, one of the columns contains datetime values for example:</p>
  
  <p>2013-10-11 10:41:00</p>
  
  <p>Now what I want is to set a condition to get for example all the values that are from the last 24 h, so I did this:</p>
  
  <pre><code>SELECT *
  FROM  data
  WHERE timediff(now(), myDate) &lt; '24:00:00'
  </code></pre>
  
  <p>But for some reason, for example, right now it is 2013-10-11 20:46 and when I run this script, the values I get go all the way from 2013-10-01 10:47:00.</p>