I am trying to Order my dataset By Datetime in SQL Server. Using
dd/mm/yyyy format. You can assume following query for simplicity.
Select CONVERT(NVARCHAR(50), DateColumn, 103) from myTable order by DateColumn DESC;
But it returns records only sorted by
dd and ignores mm,yy.You can have a look over following data.
What should i do so that it may also include
mm and yy as well while ordering.