how to convert/format date format in sql serverLocked
hi im using sql 2005, I have a varchar column with values in the date format as
21-09-1982 meaning 21-sep-1982
23-05-1981 ” 23-may-1981
25-12-1972 ” 25-dec-1972
I want to format them to read in the format 21-sep-1982 (dd-mmm-yyy)
but it seems my sql server reads them as mm-dd-yyyy when i try to use convert or cast
it says the conversion resulted in an out of range value.
How can i format my sql to read them as dd-mmm-yyyy?