Question: how to change date format from mm/dd/yyyy to dd/mm/yyyy in sql server?
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.