Saturday, February 25, 2012

Date format

How do I get the following date format 2005-01-31 to be 01/31/2005?
SELECT
convert(datetime,Convert(varchar(10),getdate(),20) ,110) as Dateselect convert(varchar,getdate(),101) ?

No comments:

Post a Comment