title: Convert DateTime to a different format in sql
body: <p>How can I convert/cast this datetime format: <strong>06/17/2012 12:00:00 AM</strong></p>
  
  <p>To this date format : <strong>2012/06/17</strong></p>
  
  <p>in a SQL Update Statement?</p>
  
  <p>I need to change to fields. BeginDate, and EndDate. Both DateTime Types.</p>
  
  <p>This is my Update statement so far:</p>
  
  <pre><code>Update discount set DiscountPromotionalID = @DiscountPromotionalID,
     isActive =@isActive, Title = @Title, BeginDate = @BeginDate, EndDate = @EndDate, 
      DiscountPercentage = @DiscountPercentage
  
      where DiscountPromotionalID = @DiscountPromotionalID;" 
  </code></pre>