title: Converting nvarchar to DATE
body: <p>I have a column in SQL where in the data is stored as 102915, 060315 and so on.
  The data type of the column is <code>nvarchar(50)</code>. I want to convert the above data to a date format.</p>
  
  <p>It should look like 10-29-15 or 10/29/15.</p>
  
  <p>How can I convert the above in SQL Server Management Studio 2008?</p>
  
  <p>Tried quite a few things: One of them is </p>
  
  <pre><code>create view v1 
  as
      Select 
          CAST([ISSUE] as date) as ISSUE,
          CAST([EXPIRE] as date) as EXPIRE
      from tablename
  </code></pre>
  
  <p>The view is being created.</p>
  
  <p>Note: ISSUE and EXPIRE are the column names which have values like 100515, 060315 and I need to convert all the values in those columns to 10-05-15 or 10/05/15.</p>
  
  <p>When I do a <code>select * from v1;</code> I get the following error:</p>
  
  <blockquote>
    <p>Conversion failed when converting data and/or time from character string. </p>
  </blockquote>