title: SQL Server - Check if given date+time is between two datetime variables by exact date+time
body: <p>I have two datetime columns in a DB table: @Start and @End.</p>
  <p>Both columns contain the date and time, for example:</p>
  <pre><code>@Start: 2018-10-01 19:00:00
  @End: 2018-10-10 23:59:00
  </code></pre>
  <p>I want to know if the <strong>current date</strong> is exactly between both datetimes considering the dates and the times.</p>
  <p>So, <code>2018-10-08 16:37</code> and <code>2018-10-10 23:59:00</code> would match this range
  and <code>2018-10-11 00:00:00</code> would not.
  (In this case this date is one minute later than the End date, so it is not between my datetime range).</p>
  <pre><code>SELECT Id FROM Table1 WHERE GETDATE() BETWEEN Start AND End
  </code></pre>
  <p>I don't use GETDATE() in real code, I use an argument. The problem is that current date argument may contain seconds and milliseconds like <code>23:59:59.123</code>. My code treats such date as not conforming given range. But I don't care about s/ms.</p>
  <p>Is there a workaround?</p>
  <h2>Update:</h2>
  <p>The <strong>precision</strong> I want to achieve is in <strong>minutes</strong>. So I do not even need to take in account the seconds nor the milliseconds. The date time format I would be working on would be 'yyyy-MM-dd hh-mm' but I do not know how to use the BETWEEN clause converting the Start and End to the shown format so I can compare the dates.</p>