how to convert yyyy-mm-dd to dd-mm-yyyy in sql server?
['--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.']