第几周SQL函数

给定日期是当年的第几周-给定日期所在月第一天是当年的第几周SELECTDATEPART(WEEK,@Date)-DATEPART(WEEK,DATEADD(MONTH,DATEDIFF(MONTH,0,@Date),0))+1[WeekOfMonth]SELECTDATEPART(WEEK,@Date)-DATEPART(WEEK,DATEADD(DAY,1-DATEPART(DAY,@Date),@Date))+1[WeekOfMonth]GO