title: Temporarily change format of a date column in SQL Query output
body: <p>I am pulling data from SQL Server, and the date on our back end is formatted prtty ugly, like so:</p>
  
  <pre><code>2014-01-10 00:00:00.000
  </code></pre>
  
  <p>I was wondering if there is some sort of funciton that I can run in my query to display the date column differently in my output? I don't want to actually alter the way in which the Column is formatted on the back end, I just want to change how it is presented to the user in the results of a sigle query. </p>
  
  <p>Thank you for your help!</p>
  
  <p>Edit: I am using SQL server 2008 R2 as my RDBMS</p>