title: Mysql date condition shows incorrect results
body: <pre><code>SELECT * 
  FROM memories 
  WHERE date &gt; unix_timestamp(DATE(NOW()) - INTERVAL 1 DAY) 
  GROUP BY user_id 
  ORDER BY date DESC
  </code></pre>
  
  <p>I use this query to get memories from 1 day</p>
  
  <p>In the date column, it is all stored as UNIX timestamp, so I use 1583212980 timestamp which is Tuesday, March 3, 2020 5:23:00 AM (30 hours before the current date) to test it.</p>
  
  <p>I get the record returned with a timestamp of 30 hours ago. </p>
  
  <p>How can I check where is the problem here?</p>