select *,cast(replytime as smalldatetime) as dd from replycontent order by dd descselect * ,convert(varchar,replytime,20) as dd from replyContent order by dd