title: Convert inconsistent string to sql datetime
body: <p>I am having date field in following format : Dec 8 2013  9:08AM (it's an nvarchar field)
  I need to convert this into more consistent and readable date format (e.g. yyyy-mm-dd).
  I tried using following query to convert it into different formats but its not working and returning same string :</p>
  
  <pre><code>CONVERT(char(11), mydate, 127)
  </code></pre>
  
  <p>Can someone please help?</p>