Question: how to convert dd/mm/yyyy to mm/dd/yyyy in sql server 2008?
Answer: --dd/mm/yyyy format. select convert (varchar,[date],103) from Test_Date. Go.
--dd-mm-yyyy format. select convert (varchar,[date],105) from Test_Date. Go.
--mm/dd/yyyy format. select convert (varchar,[date],101) from Test_Date. Go.
--mm-dd-yyyy format. select convert (varchar,[date],110) from Test_Date. Go.