title: SQL how to retrieve the middle point between two given dates?
body: <p>I have two dates:</p>
  
  <p><code>2012-10-04 12:48:56:000</code> and <code>2012-10-04 12:48:58:000</code></p>
  
  <p>Expected result is<br>
  <code>2012-10-04 12:48:57:000</code></p>
  
  <hr>
  
  <p><code>2012-10-04 12:48:56:000</code> and <code>2012-10-04 12:48:56:010</code></p>
  
  <p>Expected result is<br>
  <code>2012-10-04 12:48:56:005</code></p>
  
  <p>(the dates are fictional, since in sql server the millisecond part DATETIME datatype is increasing by 3 )</p>