title: Convert YYYY-MM-DD to MM/DD/YYYY
body: <p>I have  this DOB column in my additional information table  with YYYY-MM-DD. I need to convert let say DOB: 1949-06-15 to DOB format: MM/DD/YYYY.</p>
  
  <p>I have </p>
  
  <pre><code>SELECT CONVERT(VARCHAR(10), ai.ADDLINFO_INDEX_21, 101) as 'DOB'
  </code></pre>
  
  <p>but I still get this result: <code>1949-06-15</code>. </p>
  
  <p>I even tried </p>
  
  <pre><code>REPLACE(CONVERT(VARCHAR, ai.ADDLINFO_INDEX_21, 101), '-', '/')
  </code></pre>
  
  <p>However, the result is <code>1949/06/15</code>. </p>
  
  <p>I am looking for <code>06/15/1949</code> as the output. Can someone please help? </p>