title: ADD time 23:59:59.999 to end date for between
body: <p>I have been having an issue with using the following:</p>
  
  <pre><code>Column_Name BETWEEN @StartDate AND @EndDate. 
  </code></pre>
  
  <p>This is because the @EndDate = 00:00:00.000 for the time, which doesn't pick up all the values for that day.</p>
  
  <p>How would I convert the @EndDate (Always 00:00:00.000) to always be Date + 23:59:59.999?</p>