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