如何在GridView中正确排序日期 [英] How to correctly Sort date in GridView
问题描述
在GridView中执行排序时,结果如下:
13-Dec
19-Dec
20-Dec
14-Dec
13-Dec
10-Dec
15-Dec
16-Dec
这是不正确的,而应该是:
10月12日
13-Dec
13-Dec
14- 12月15日12月
12月16日
19-Dec
20-Dec
请帮忙'排序'这个...也是DATE类型栏...
代码是:
SELECT 状态,名称,dob,类别 FROM Family_Details
WHERE ((DATEDIFF(dd,getdate(),DATEADD(yyyy,DATEDIFF(yyyy,dob) ,getdate())+ 1 ,dob)))% 366 < = 10 ) ORDER BY DESC
我还使用过:
< span class =code-keyword> SELECT status,name,dob,category FROM Family_Details
WHERE ((DATEDIFF(dd,getdate(),DATEADD(yyyy,DATEDIFF(yyyy,dob,getdate())+ 1 ,dob)) )% 366 < = 10 ) ORDER BY CONVERT ( DATETIME ,DOB, 103 ) DESC
我得到了正确的答案:
SELECT dob FROM fd WHERE ((DATEDIFF(dd,getdate(),DATEADD(yyyy,
DATEDIFF(yyyy,dob) ,getdate())+ 1 ,dob)))% 366 < = 10 )
ORDER BY MONTH(dob)< span class =code-keyword> ASC ,DAY(dob) ASC
此查询将按日期对未来10天内的生日进行排序...
谢谢大家,也谢谢我...: )
While performing sorting in GridView this is the result:
13-Dec
19-Dec
20-Dec
14-Dec
13-Dec
10-Dec
15-Dec
16-Dec
which is not correct, instead it should be:
10-Dec
13-Dec
13-Dec
14-Dec
15-Dec
16-Dec
19-Dec
20-Dec
please help to 'Sort' this out...Also it is a DATE type column...
Code was:
SELECT status,name, dob, category FROM Family_Details
WHERE ((DATEDIFF(dd, getdate(), DATEADD(yyyy, DATEDIFF(yyyy, dob, getdate()) + 1, dob))) % 366 <= 10)ORDER BY DESC
I also used:
SELECT status,name, dob, category FROM Family_Details
WHERE ((DATEDIFF(dd, getdate(), DATEADD(yyyy, DATEDIFF(yyyy, dob, getdate()) + 1, dob))) % 366 <= 10) ORDER BY CONVERT(DATETIME, DOB, 103) DESC
I got the correct answer:
SELECT dob FROM fd WHERE ((DATEDIFF(dd, getdate(), DATEADD(yyyy, DATEDIFF(yyyy, dob, getdate()) + 1, dob))) % 366 <= 10) ORDER BY MONTH(dob)ASC ,DAY(dob) ASC
This Query will sort the Birthdays coming in next 10 days by Date...
Thanks everyone and Thanks to me too...:)
这篇关于如何在GridView中正确排序日期的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!