title: Converting SQL date formats not ending up the same
body: <p>I am trying to remove the timestamp from my date values so I end up with something like mm/dd/yy or mm/dd/yyyy.  I referenced many technet, stackoverflow, and w3schools articles but still can't get the date to appear correctly.  All of my columns in the table are defined as a datetime and they come from the same table.  </p>
  
  <p>I am using convert statements like this:  CONVERT(VARCHAR(10), E.PD_DT, 101) AS 'Paid Date'</p>
  
  <p>In place of 101 I have used 10 and 11, still have the same issue with the data (below).  What's happening is when the date value (not including the time) is 8 characters, I am getting an additional character from the time, as seen in the Claim Adjustment Date-10 and Claim Adjustment Date-11 columns.  Here is my data:</p>
  
  <pre><code>Claim Paid Date-101     Claim Paid Date     Claim Adjustment Date-10    Claim Adjustment Date-11    Claim Adjustment Date
  10/23/2012              10/23/12 12:00 AM   9/4/2012 1                  9/4/2012 1                      9/4/12 12:00 AM
  10/23/2012              10/23/12 12:00 AM   9/4/2012 1                  9/4/2012 1                      9/4/12 12:00 AM
  10/23/2012              10/23/12 12:00 AM   9/4/2012 1                  9/4/2012 1                      9/4/12 12:00 AM
  09/06/2011              09/06/11 12:00 AM   9/4/2012 1                  9/4/2012 1                      9/4/12 12:00 AM
  10/23/2012              10/23/12 12:00 AM   8/21/2012                   8/21/2012                       8/21/12 12:00 AM
  09/06/2011              09/06/11 12:00 AM   8/21/2012                   8/21/2012                       8/21/12 12:00 AM
  </code></pre>
  
  <p>The strange thing is that all of the dates in the "Claim Paid Date" column have a zero for padding if the month or day is &lt; 10.  This makes the convert come out just fine but where the month or day is &lt; 10 and doens't have a zero is where I get my problem.</p>