title: How do I change the format of my date in SQL Server
body: <p>I am using SQL Server 2008 R2 and I have a field called StartDate in my tables that look like the following,</p>
  
  <p>1977-10-17 00:00:00.000</p>
  
  <p>how do I change those values to represent 10-17-1977?  Also, if the date is 1900-01-01 00:00:00.000 I want to change it to null value.  Is there a command or stored procedure for these types of changes?</p>
  
  <p>thanks
  Nick</p>