title: Convert dd/mm/yy string to yyyy-mm-dd
body: <p>I am having issues converting a string in <code>dd/mm/yy hh:mi:ss</code> format to <code>yyyy-mm-dd hh:mi:ss</code> format.</p>
  
  <p>I have tried using <code>CONVERT()</code> as follows:</p>
  
  <pre><code>select CONVERT(VARCHAR, '11/10/11 10:56:58', 120)
  </code></pre>
  
  <p>But that returns no change:</p>
  
  <pre><code>11/10/11 10:56:58
  </code></pre>