s.lakhanpal6776 (3/15/2013)
your simple way of doing this is :-select cast(month(GETDATE()) as varchar(2))+'/'+cast(day(GETDATE()) as varchar(2))+'/'+cast(year(GETDATE()) as varchar(4))
Using CONVERT with correct format code is the simplest. This is a lot of work.