If you look up CAST AND CONVERT in BOL they have a list of the possible date formats. The date format that you run defines the order of the entries when converting. I tried using set dateformat to do a direct CAST however it did not work (don't know why).