CONVERT date to varchar
1> 2> --Nested Functions 3> 4> SELECT CONVERT(VarChar(20), GETDATE(), 101) 5> 6> GO -------------------- 10/14/2006 (1 rows affected) 1>