关于时间排齐的问题,望高手相助(在线等待中.......)

[21wing]

字段(timenow)中有下列数据
2006-2-9 10:30:41
2006-2-10 16:30:41

2006-2-9 9:30:41

要求排列为:
2006-10-9 16:30:41
2006-2-10 16:30:41
2006-2-9 10:30:41
2006-2-9 9:30:41

不知SQL语句怎样写??

[21wing]

补回最顶时间,,,2006-10-9 16:30:41

[$扫地僧$]

select * from 表 order by timenow DESC

[21wing]

如果是这样排只会得出:
2006-2-9 9:30:41
2006-2-10 16:30:41
2006-2-9 10:30:41
2006-10-9 16:30:41

[bugchen888]

SELECT *
FROM 表
ORDER BY CONVERT(DATETIME,timenow,120) DESC

[21wing]

好,,谢谢,,接分吧,,

[子陌红尘]

把字符型转为日期型再排序即可：
-----------------------------------------------------------------
declare @t table(timenow varchar(30))
insert into @t select '2006-2-9 10:30:41'
insert into @t select '2006-2-10 16:30:41'
insert into @t select '2006-10-9 16:30:41'
insert into @t select '2006-2-9 9:30:41'

select * from @t order by cast(timenow as datetime) desc

/*
timenow
------------------------------
2006-10-9 16:30:41
2006-2-10 16:30:41
2006-2-9 10:30:41
2006-2-9 9:30:41
*/