title: find a time today and yesterday
body: <p>I want to find a time today and yesterday in sql query.
  My example is in error and does not find all the rows.
  Database is sql oracle.
  I would be grateful for any help.
  example:</p>
  
  <pre><code>and  (to_char(zsd.SB_ACTUAL+600/1440, 'dd.mm.yyyy') &gt; to_char(current_date-1, 'dd.mm.yyyy')
  </code></pre>