title: SYSDATE but specify the time
body: <p>I want to say the follow but substitute the date with SYSDATE but the time between is what I want to adjust. What would the syntax be?</p>
  
  <p>where mydatefield between <code>SYSDATE+'0001'</code> and <code>SYSDATE+'2359'</code></p>
  
  <pre><code>...
  WHERE TO_CHAR( MOPACTIVITY.MOPNOTIFICATIONSENDAT , 'yyyy-mm-dd hh24:mi' )
    BETWEEN '2013-07-26 00:00:01' AND '2013-07-26 23:59:59'
  ;
  </code></pre>