Sql Server Sorting Date With Hours/Mins : I have a complex date column that I need to sort by. SQL Server 2008



**My Query:**

    SELECT DivisionName as Division, StoreNum as Store, LeadName as Lead, Type, ChangeType,Changes, 
    UpdatedBy, 
    convert(varchar(10),UpdatedDate, 101) + right(convert(varchar(32), UpdatedDate,100),8) as UpdatedDate FROM m 
    WHERE DivID!=0 
    ORDER BY convert(varchar(10),UPDATEdDate, 101) desc, right(convert(varchar(32), UPDATEdDate,100),8) asc



**The format:** in the database: smalldatetime 2016-01-25 16:50:00

**And to the display value, I use:**    

    convert(varchar(10),UpdatedDate, 101) + right(convert(varchar(32), UpdatedDate,100),8) as UpdatedDate

**My issue:** (Hour/Minute Sorting), I need the 7:40PM row at top.

[![enter image description here][1]][1]


  [1]: http://i.stack.imgur.com/lB6zb.jpg