我有一个数据:id date
1 2007-08-14 17:00:00:44.777
2 2007-08-07 13:01:44:22.442
3 2006-08-01 14:00:44:42.422
我只想按日期排序,时间不加入排序,怎么办?
1 2007-08-14 17:00:00:44.777
2 2007-08-07 13:01:44:22.442
3 2006-08-01 14:00:44:42.422
我只想按日期排序,时间不加入排序,怎么办?
1 2007-08-14 17:00:00:44.777
2 2007-08-07 13:01:44:22.442
3 2006-08-01 14:00:44:42.422
select * from tb order by convert(varchar(10),date , 120) --desc
1 2007-08-14 17:00:00:44.777
2 2007-08-07 13:01:44:22.442
3 2006-08-01 14:00:44:42.422
我只想按日期排序,时间不加入排序,怎么办?
----------------select * from t order by convert(varchar(10),date,120)