To convert a datetimefield to a string you can use the next configurations

select convert(nvarchar,getdate(),<nr>)

Nr	Sybase ASE	MS SQL Server
101	12/04/2009	12/04/2009
102	2009.12.04	2009.12.04
103	04/12/2009	04/12/2009
104	04.12.2009	04.12.2009
105	04-12-2009	04-12-2009
106	04 Dec 2009	04 Dec 2009
107	Dec 04, 2009	Dec 04, 2009
108	11:13:58	11:07:54
109	Dec 4 2009 11:13:58:206AM	Dec 4 2009 11:07:54:263AM
110	12-04-2009	12-04-2009
111	2009/12/04	2009/12/04
112	20091204	20091204
113	2009/04/12	04 Dec 2009 11:07:54:263
114	12/2009/04	11:07:54:263
120		2009-12-04 11:07:54
121		2009-12-04 11:07:54.263