title: SQL Convert dd/mm/yy to yymmdd
body: <p>I have been trying to achieve this all day, I have followed numerous tutorials and can't seem to crack it, I have been trying things like:</p>
  
  <pre><code>select CONVERT(VARCHAR(10), DATE, 131) from Table
  </code></pre>
  
  <p>yet it does not seem to change anything.</p>
  
  <p>Any advice or help would be appreciated. Thankyou in advance.</p>