title: SQL Server CONVERT and CAST not returning the correct date format
body: <p>I have a table in SQL Server with a column <code>RGSTR_DATE</code> that is of <code>varchar(10)</code> data type, and it has values like <code>2016-01-23</code>, <code>1998-08-12</code>, etc... </p>
  
  <p>I want to select and convert those values to <code>20160123</code>, <code>19980812</code>, etc...  </p>
  
  <p>I tried running these queries:</p>
  
  <pre><code>SELECT CONVERT(DATE, CAST(RGSTR_DATE AS DATE), 112) 
  FROM [project].[dbo].[my_table];
  
  SELECT CONVERT(VARCHAR(10), RGSTR_DATE, 112) 
  FROM [project].[dbo].[my_table];
  </code></pre>
  
  <p>But the results that came back were still <code>2016-01-23</code>, <code>1998-08-12</code> etc... </p>
  
  <p>What am I doing wrong?</p>