title: formating of dates in sql server
body: <p>This is my query:</p>
  
  <pre><code>SELECT [projectname]
      , CONCAT ([Budget Health]
              , [ProjectBaseline0StartDate
              , [ProjectActualStartDate]
              , [ProjectStartDate]) AS budgethealth
  FROM [dbo].[MSP_EpmProject_UserView];
  </code></pre>
  
  <p>My output is:</p>
  
  <pre><code>projectname budgethealth
  ------------------------
  abc         5% varianceApr  7 2015  8:00AMApr  7 2015  8:00AMApr  7 2015  8:00AM
  </code></pre>
  
  <p>I want info of budget health in this form:</p>
  
  <pre><code>      &lt;5% variance
        Apr/07/2015
        Apr/08/2015
        Apr/08/2015
  </code></pre>
  
  <p>NOTE: I want time to be removed and date in this format.
  plz help.</p>