title: Convert varchar to datetime in sql which is having millisec
body: <p>I have a column <code>abc varchar(100)</code> with data like <code>2011-09-26 16:36:57.810000</code></p>
  
  <p>I want to convert this column to <code>DATETIME</code>...</p>
  
  <p>But doing a </p>
  
  <pre><code>Convert(DATETIME, abc,120) 
  </code></pre>
  
  <p>is giving this error:</p>
  
  <blockquote>
    <p>Conversion failed when converting date and/or time from character string.</p>
  </blockquote>
  
  <p>Can any one please help me convert my <code>varchar</code> format to <code>datetime</code> in SQL Server 2008?</p>
  
  <p>Thanks in advance</p>