title: How do i convert a date to mm/dd/yyyy in my where clause
body: <p>I have thousands of records that were added today but at different hours of the day, The only way I'm able to see them is if I do ORDER BY ADDdate DESC</p>
  
  <p>However, i need to make an update statement where I want to update a particulr field using WHERE clause with the date</p>
  
  <p>The problem is, since they were all entered at different times, how am i able to CAST/CONVERT this field so that I can only do something like....</p>
  
  <p>Basically every added record has a AddDate field in datetime format, i want it converted to mm/dd/yyyy format.</p>
  
  <pre><code>Update SpecialField
  SET SpecialField = NULL
  Where ADDdate = '09/18/2017'
  </code></pre>
  
  <p>Please help. Thanks.</p>