title: how to convert date to a format `mm/dd/yyyy`
body: <p>I'm having a <code>sql table</code> with date column named <code>CREATED_TS</code> which holds the dates in different format eg. as shown below</p>
  
  <pre><code>Feb 20 2012 12:00AM
  11/29/12  8:20:53 PM          
  Feb 20 2012 12:00AM
  11/29/12  8:20:53 PM          
  Feb 20 2012 12:00AM
  11/29/12  8:20:53 PM          
  Nov 16 2011 12:00AM
  Feb 20 2012 12:00AM
  11/29/12  8:20:52 PM
  </code></pre>
  
  <p>Now I want to convert these to format <code>mm\dd\yyyy</code> before as i am comparing the dates in <code>WHERE</code> clause of my <code>SELECT</code> query. </p>
  
  <p>I tried using</p>
  
  <pre><code>CONVERT(VARCHAR(10),CREATED_TS,101)
  </code></pre>
  
  <p>but got the result as,</p>
  
  <pre><code>Feb 20 201
  11/29/12  
  Feb 20 201
  11/29/12  
  Feb 20 201
  11/29/12  
  Nov 16 201
  Feb 20 201
  11/29/12  
  </code></pre>
  
  <p>I need the result as eg. <code>02/20/2012</code> in order to compare.</p>
  
  <p>Any help will be appreciated.</p>