title: Oracle SQL - using SYSDATE to display
body: <p>Here is the table:</p>
  
  <pre><code>Col1    Col2    Col3
  ---------------------------------------
  4567    102     5/5/2011 3:37:41 PM
  9876    102     5/5/2011 3:37:43 PM
  1234    104     5/5/2011 12:46:16 PM
  9999    104     5/5/2011 12:47:09 PM
  9999    104     5/5/2011 12:47:15 PM
  </code></pre>
  
  <p>How can I use the <code>SYSDATE</code> to fetch only one or more record(s) using rapid display on a report via seconds 'SS' and/or minutes 'MI'? I know about BETWEEN fxn, but dealing with seconds, it's kind of slippery slope to me. Any ideas?</p>