3>4> SELECT 'ANSI Date: ' + CONVERT(VarChar(50), GETDATE(), 102)5> GO-------------------------------------------------------------ANSI Date: 2008.08.07(1 rows affected)