title: records from yesterday in postrgesql
body: <p>I have an application in which I've used MySQL. I had a report that stretched records of the last 24 hours. I used the query:</p>
  
  <pre><code>WHERE (DATE_SUB(CURDATE(), INTERVAL 1 DAY) &lt;= FROM_UNIXTIME(`workorder`.`CREATEDTIME` / 1000))
  </code></pre>
  
  <p>Now I have to use PostgreSQL and do not know how to make a report of the last 24 hours.
  Can any of you help?</p>