Look at cast or convert using a date style http://msdn.microsoft.com/en-us/library/ms187928.aspx, style 100 or 109 may be the ones to go for.