Question: how to convert dd/mm/yyyy to mm/dd/yyyy in sql?
Answer: First, the quick answer: DECLARE @x VARCHAR(200); SELECT @x = '27-09-2013 16:15:00 CST' SELECT CONVERT(CHAR(10),CONVERT(DATETIME,LEFT(@x,10),105),101);