title: SQL Check Current time is between two DATETIME columns
body: <p>I need to check whether the current time is between two datetime column values.</p>
  
  <p>And I only need to check the time is between the range and I don't want to check the date. </p>
  
  <p>I know how to check a date is exists between a daterange like below</p>
  
  <pre><code>SELECT
      *
  FROM 
      Table1 T
  WHERE 
      CAST(GETDATE() AS DATE) BETWEEN T.StartDate AND T.EndDate
  </code></pre>
  
  <p>We have stored start date and end date as folllows..</p>
  
  <pre><code>StartDate - 1900-01-01 08:00:00.000
  EndDate   - 1900-01-01 19:00:00.000
  </code></pre>
  
  <p>Is there something similar to this to check whether the time is exists in a date range?</p>