Question
Thread display: Collapse - |
All Answers
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
how to convert/format date format in sql server
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?