SQL Server 2005 Convert DateTime Format

http://blog.sqlauthority.com/2009/08/06/sql-server-get-time-in-hourminute-format-from-a-datetime-get-date-part-only-from-datetime/


http://www.ezineasp.net/post/SQL-Server-2005-Convert-DateTime-Format.aspx