SELECT *, CAST (ReplyTime As SmallDateTime) AS DD from replycontent Order by DD Descselect *, Convert (varchar, replytime, 20) as dd from replycontent Order By DD