ezzadin
asked on
Convert varchar to MM/dd/YYYY
Hi,
I have a field that is formatted as Varchar and the value is Wednesday, June 20, 2012.
How can this be converted to MM/dd/YYYY?
Thanks.
I have a field that is formatted as Varchar and the value is Wednesday, June 20, 2012.
How can this be converted to MM/dd/YYYY?
Thanks.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks.
SELECT CONVERT(VARCHAR(10), GETDATE(), 101) AS [MM/DD/YYYY]
replace GETDATE() with your date