Access:select format(now,'ww') 結果:47
ASP.NET(vb.net): 結果:46
1.Dim tdate As Date = CDate("1/1/" & Format(Now, "yyyy"))
Dim ta = Microsoft.VisualBasic.DateDiff(DateInterval.WeekOfYear, tdate, Now)
2.Dim ta = Microsoft.VisualBasic.DateDiff(DateInterval.WeekOfYear, #1/1/2005#, Now)
MySQL: 結果:46
1.select weekofyear('2005-11-15')
2.select weekofyear(now())