獲取今天是今年得第幾周得函數
1
public static int WeekOfTheYear()
2
{
3
//獲取
4 CultureInfo myCI = new CultureInfo("zh-CN");
5 System.Globalization.Calendar myCal = myCI.Calendar;
6
7 //日期格式
8 CalendarWeekRule myCWR = myCI.DateTimeFormat.CalendarWeekRule;
9 DayOfWeek myFirstDOW = myCI.DateTimeFormat.FirstDayOfWeek;
10
11 //本周為第myCal.GetWeekOfYear( DateTime.Now, myCWR, myFirstDOW )周
12 int thisWeek=myCal.GetWeekOfYear( DateTime.Now, myCWR, myFirstDOW );
13 return thisWeek;
14
}
SQL語句中如何獲得當前為這一年的第幾周呢？public static int WeekOfTheYear()2
{ 
3
//獲取4
CultureInfo myCI = new CultureInfo("zh-CN");5
System.Globalization.Calendar myCal = myCI.Calendar;6
7
//日期格式8
CalendarWeekRule myCWR = myCI.DateTimeFormat.CalendarWeekRule;9
DayOfWeek myFirstDOW = myCI.DateTimeFormat.FirstDayOfWeek;10
11
//本周為第myCal.GetWeekOfYear( DateTime.Now, myCWR, myFirstDOW )周12
int thisWeek=myCal.GetWeekOfYear( DateTime.Now, myCWR, myFirstDOW );13
return thisWeek;14
}比如獲得周排行的功能，我是這么做的
表WeekStat
UserNO int not null,
Author varchar(64) not null,
Year int not null,
Week int not null,
PostCount int
查詢語句
SELECT PostCount as ReturnNum, Author
FROM WeekStat
WHERE (Year = DATEPART(Year, GETDATE())) AND (Week = DATEPART(Week, GETDATE()))
ORDER BY PostCount DESC
這樣就可以得到周排行了，性能比以前哥們用group by的要高不只百倍。
group by的在100W數據的時候已經超時了。這個根本就沒有多少IO操作和CPU占用
作者：jillzhang
出處：http://jillzhang.cnblogs.com/
本文版權歸作者和博客園共有，歡迎轉載，但未經作者同意必須保留此段聲明，且在文章頁面明顯位置給出原文連接，否則保留追究法律責任的權利。
出處：http://jillzhang.cnblogs.com/
本文版權歸作者和博客園共有，歡迎轉載，但未經作者同意必須保留此段聲明，且在文章頁面明顯位置給出原文連接，否則保留追究法律責任的權利。
浙公網安備 33010602011771號