title: SQL Server adding the slashes to the date on the fly
body: <p>I am trying to figure out how to add some sort of mask to my data. Currently I have a query like this:</p>
  
  <pre><code>SELECT [EmployeeTC_No] AS "Employee TC#"
        ,[pye_nlast] AS "Name Last"
        ,[pye_nfirst] AS "Name First"
        ,[Dept] AS "Department"
        ,[pye_status] AS "Active"
        ,[HireDate] AS "Hire Date"
        ,[SeparationDate] AS "Separation Date"
    FROM [testing].[dbo].[testing]
  </code></pre>
  
  <p>The data in the hiredate and separationdate column shows as 09282015 but I need the dates to show the slash ("/") like 09/28/2015 is there any way to add some kind of mask on the fly for these?</p>