sqlserver中对不规范时间的排序处理

来源:互联网 发布:人工智能 城市管理 编辑:程序博客网 时间:2024/04/29 11:43
select *,cast(replytime as smalldatetime) as dd from replycontent order by dd desc


select * ,convert(varchar,replytime,20) as dd from replyContent order by dd