JameMeck
asked on
MS SQL 2008 R2, convert datetime in string to datetime format.
I have a column with string format: dd/mm/yyyy
Now I want to convert it to datetime format: mm/dd/yyyy
How can I do?
Now I want to convert it to datetime format: mm/dd/yyyy
How can I do?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Cast (Datefield as datetime)
Try this
Declare @sdate as datetime
set @sdate='2011-12-15' --15th December 2011
Select Convert(nvarchar(11),@sdate,101) as [mm/dd/yyyy]
,Convert(nvarchar(11),@sdate,103) as [dd/mm/yyyy] from [test]
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks! I got it now.
Open in new window