Dupa cum a mentionat si Diana, gasiti formatele disponibile pentru conversie in Books Online:
CAST and CONVERT (Transact-SQL)
Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro