select * from staff where datediff(ww,'2007/9/30',lgn_Time)=0 order by lgn_Time; 然后再把数据存到集合,获取时从周日的数据开始获取.