3> SELECT 'German Date: ' + CONVERT(VarChar(50), GETDATE(), 104)4> GO---------------------------------------------------------------German Date: 12.10.2006(1 rows affected)1>