Question: how to convert mm/dd/yyyy to dd/mm/yyyy in sql server?
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);