convert varchar(10) = '2014-04-06' to mmddyyyy format.

[jl98]

Other than using substring('2014-04-06',6,2) + ... Is there a better way to convert the varchar column value to MMDDYYYY format ?

[Rabbit]

I wouldn't say it's better but you could use the convert function with style 101 and use a replace to remove the forward slashes.

[Luuk]

select convert(datetime,'2013-04-06')

more readings: here