anotherbyte.net

Some very useful date formatting T-SQL.

http://www.sql-server-helper.com/tips/date-formats.aspx

Also shows some custom date formats that are not built into SQL Server.