title: Conversion failed when converting date and/or time from character string Error
body: <pre><code>Select CONVERT(Date, '13-5-2012')
  </code></pre>
  
  <p>When i run the above T-SQL statement in Management Studio, i get i get the following error:</p>
  
  <p><strong>"Conversion failed when converting date and/or time from character string"</strong> </p>
  
  <p>Is there away i can cast that value to a valid Date type successfully? I have such values in a nvarchar(255) column whose dataType i want to change to Date type in an SQL Server table but i have hit that error and i would like to first do a conversion in an Update statement on the table.</p>