title: Convert a varchar to datetime including hour minute and seconds
body: <p>I have a date column that is in varchar. I need to convert it to datetime format.</p>
  <blockquote>
  <p>My data looks like this in varchar:29-JUL-11 02.44.29.984664000 PM</p>
  <p>I want this to be in datetime format like this: 29-JUL-11 02.44.29.984664000 PM</p>
  </blockquote>
  <p>I am using following query:</p>
  <pre><code>select convert (datetime, (convert (float, [KYC_STATUS_CHANGED_DATE])),120) from [dbo].[KYC_Data_31122012]
  </code></pre>
  <p>But it is giving following error:</p>
  <blockquote>
  <p>Error converting data type varchar to float</p>
  </blockquote>
  <p>What am I doing wrong?</p>