If you are concerned about formatting output, you would be far better off handling all of that through whatever application you're using for the user interface. If you must pre-format in SQL Server, take a look at the CONVERT function in Books Online.
If you are having issues with how SQL Server is interpreting inputted dates, take a look at this article.