title: MYSQL TIMESTAMPDIFF function is not working
body: <p>I am trying to use TIMESTAMPDIFF function in one of my queries and is making an headache for me.</p>
  
  <p><strong>TABLE</strong></p>
  
  <pre><code>id  |  web_address    |  timeperiod  |  timeperiod_exp
  
  1   |  www.google.com |  1564692614  |  1564779014
  </code></pre>
  
  <blockquote>
    <p>1564692614 = GMT: Thursday, August 1, 2019 8:50:14 PM</p>
    
    <p>1564779014 = GMT: Friday, August 2, 2019 8:50:14 PM</p>
  </blockquote>
  
  <p><strong>WHATS THE PROBLEM ?</strong></p>
  
  <p>As one can see the difference between these two timestamps is exactly 1 day but is returning no records.</p>
  
  <pre><code>SELECT * FROM mytable WHERE TIMESTAMPDIFF(DAY, timeperiod, timeperiod_exp) &gt;= 1
  </code></pre>
  
  <p><strong>WHERE IS THE FIDDLE ?</strong></p>
  
  <p><a href="https://www.db-fiddle.com/f/udmrC2xdvrEEKGxEF7ty84/7" rel="nofollow noreferrer">https://www.db-fiddle.com/f/udmrC2xdvrEEKGxEF7ty84/7</a></p>
  
  <p><strong>WHAT SHOULD BE DONE ?</strong></p>
  
  <p>Please take a look at the fiddle above and suggest what should be modified or other function in place of timestampdiff.</p>