title: DateTime to milliseconds from midnight
body: <p>How can I convert the <em>time</em> part of a given <code>DATETIME</code> to the number of milliseconds since midnight? For instance,</p>
  
  <pre><code>'2011-08-29 00:00:00' -&gt; 0
  '2011-08-28 00:00:00' -&gt; 0
  '2011-08-29 01:00:00' -&gt; 3600000
  </code></pre>
  
  <p>Is there any simple way to do this in SQL Server 2005?</p>