title: Converting smalldatetime in T-SQL
body: <p>The following is not converting from i.e. July 12, 2010 to 07/12/10</p>
  
  <pre><code>SELECT Top 1 CONVERT(smalldatetime,[ShipDate],1) FROM [Order]
  </code></pre>
  
  <p>ShipDate is a column in [Order] of type smalldatetime.</p>