title: Select shift based on current time between start and end time
body: <p>I want to Select shift using <strong>Current Time</strong> Between <strong>StartTime</strong> to <strong>EndTime</strong></p>
  
  <pre><code>ShiftID     OrgID   ShiftName   StartTime                   EndTime
  13          1-1     General     1900-01-01 09:00:00.000     1900-01-01 17:00:00.000
  14          1-2     Morning     1900-01-01 08:00:00.000     1900-01-01 15:00:00.000
  15          1-3     Evening     1900-01-01 15:00:00.000     1900-01-01 21:00:00.000
  16          1-4     Night       1900-01-01 21:00:00.000     1900-01-01 08:00:00.000
  </code></pre>