Question: how to convert date format yyyy-mm-dd 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.