title: SQL Server 2012 - Convert CYYMMDD date to YYYYMMDD
body: <p>I have a table with just over 200,000 entries where the date is stored as CYYMMDD where C is the century (currently stored as integers). For example, December 5, 1992 would show up as <code>1921205</code> and April 25, 2016 would show up as <code>2160425</code>. I need to display these results in a new table in a YYYMMDD format. So for the two examples earlier it would be <code>19921205</code> and <code>20160425</code>. I have tried using </p>
  
  <pre><code>CONVERT(VARCHAR(8),[DATE], 112)
  </code></pre>
  
  <p>This doesn't give an error but it also doesn't do the conversion so all my dates still look the same. What am I doing wrong?</p>