CONVERT has the third parameter "style" which can be used when converting datetime to string
The style parameter can also used when converting float/real, money/smallmoney, xml and binary/varbinary/char/varchar.
See BOL for more information.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes