SQL Query returns datetime, but I only need date. How do I remove the time and format the date?

I have a sql query that returns a datetime field as 2014-09-08 18:15:00.000.  I need to figure out how to remove the time, and also change the date to be mm/dd/yyyy.    I've always just done this in my code behind, so I don't know how to do this in sql.