title: How to convert from one date format to another, in Microsoft SQL server?
body: <p>I have a date that is stored in 'MM/DD/YYYY' (101) format and I would like to convert it to 'DD/MM/YYYY' (103).  The source date (date in 101 format) is stored as a varchar initially, so I am guessing you would first need to convert it to a date type before changing it's format.</p>
  
  <p>So practically my question is, "how do you change the format of a date stored as a varchar?".</p>