title: Convert Date to CYYMMDD SQL-Server
body: <p>I am interested in converting a date value to <code>CYYMMDD</code> using native SQL Server 2012 functions.</p>
  
  <p>I checked here:</p>
  
  <p><a href="http://www.sql-server-helper.com/tips/date-formats.aspx" rel="nofollow">http://www.sql-server-helper.com/tips/date-formats.aspx</a></p>
  
  <p>and couldn't find anything.</p>
  
  <p>Anyone know?</p>
  
  <p>C stands for century I guess...</p>