title: SQL convert time to milliseconds
body: <p>I have this time-duration: <code>00:00:23.323</code>
  I want to convert it in sql to milliseconds.</p>
  
  <p>EDIT://
  I tried this but it isn't very nice:</p>
  
  <pre><code>SELECT  (DATEPART(hh,'12:13:14.123') * 60 * 60 * 1000)
  SELECT  (DATEPART(n,'12:13:14.123') * 60 * 1000)
  SELECT  (DATEPART(s,'12:13:14.123') * 1000)
  SELECT  DATEPART(ms,'12:13:14.123')
  </code></pre>
  
  <p>How does it work?</p>
  
  <p>Thanks for your answers.</p>