title: Check if time is between two times
body: <p>i want to do the following in SQL :</p>
  
  <p>I have three shifts:</p>
  
  <blockquote>
    <p>Shift 1 :  07:00 - 14:59<br> Shift 2:   15:00 - 22:59<br> Shift 3:   23:00 -
    06:59</p>
  </blockquote>
  
  <p>I want to know which shift i am actually in, depending on my sysdate (time).
  The following statement doesn't work for "02:00". 
  start_time and end_time are varchar2</p>
  
  <pre><code> SELECT *  FROM abc
      WHERE to_char(sysdate, 'HH24:MI') 
      between start_time and end_time;
  </code></pre>
  
  <p>How can i do that?</p>