SQL Query - Change my long date format to DD-MM-YYYY

I have been researching a lot of similar questions on how to convert date format to DD-MM-YYYY but none work for the date format I'm using.

This is the date format I'm working with: Wednesday, October 14, 2015 5:57 PM

And this IS a "date" field not a text field. I have a feeling that the inclusion of the day of the week is precluding my other attempts from working.

I'm new to SQL so forgive me if I'm overlooking something obvious.

Thank you!