RE: date format 7/31/2013 – SQLServerCentral

SSC Guru

Points: 442467

March 15, 2013 at 2:31 am

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.