title: Condition for current time greater than or equal to from time and current time less than or equal to time in ORACLE
body: <p>Condition not working because using TO_CHAR(),but how to extract time? following is my query:</p>
  
  <pre><code>SELECT *
    FROM SUPPLY_TIMING
   WHERE TO_CHAR (SYSDATE, 'HH:Mi') &gt;= TO_CHAR (FROM_TIME, 'HH:Mi')
         AND TO_CHAR (SYSDATE, 'HH:Mi') &lt;= TO_CHAR (TO_TIME, 'HH:Mi')
  </code></pre>