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.

So practically my question is, "how do you change the format of a date stored as a varchar?".