Home Forums SQL Server 2008 SQL Server 2008 - General date format 7/31/2013 RE: date format 7/31/2013
s.lakhanpal6776
SSC Rookie
Points: 33
More actions
March 15, 2013 at 1:46 am
#1597371
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))