Convert datetime to europe default without time I have a datetime field that I need to convert into the format DDMONYY (27Aug12).  I am currently using convert(nvarchar(30),DateToConvert,13), but that also spits out the time.  How can I easily convert a date to the format I need?
Instead of your hack with replace, why not just cast to the right data type? This doesn't need to be nvarchar and the only reason it contains time is because you included too many characters. You can of course apply your replace here as well (or you could do that at the client).

SELECT CONVERT(CHAR(11),GETDATE(),13)
UNION ALL
SELECT CONVERT(CHAR(11), DATEADD(DAY, 10, GETDATE()), 13);


Results:

27 Aug 2012
06 Sep 2012