title: How can I select records ONLY from yesterday?
body: <p>I've spent hours searching the web for an answer to this question...</p>
  
  <p>Here's what I currently have:</p>
  
  <pre><code>select  *
  from    order_header oh
  where   tran_date = sysdate-1
  </code></pre>