Contents tagged with SQL Server
I have a table with only one column which stores date values as shown below
Now I want to sort the data in the descending order of the date and needs to display it in the mm/dd/yyyy format. So, Select Convert(VarChar(10),FeedDate,103) FeedDate From Test Order By FeedDate Desc
Can anyone tell me why is this is not getting sorted as I intended ?