title: Convert nvarchar to DateTime in this format 'May 21 2013 9:45AM'
body: <p>I have a text field that is in this format <code>May 21 2013  9:45AM</code>.  How would I convert that to <code>datetime</code>?  I tried the following</p>
  
  <pre><code>UPDATE WaterRevLienInfo
  SET    LienDate = CONVERT(DATETIME, CONVERT(VARCHAR(30), LienDate), 101) 
  </code></pre>
  
  <p>It works as a select and comes out like <code>2013-05-21 09:45:00.000</code> but not as an update.  Any help would be great.  </p>