sql 周转换为日期自定义函数

SQL中，将周期转换为日期，取当周第一天的日期，格式：dbo.get_WeekToDate(Week,WeekFormat)

CREATE Function [dbo].[get_WeekToDate](@week varchar(4),@wkformat varchar(4))  
   Returns  date
AS  
BEGIN  
  declare @year varchar(10),@week_l int,@week_date date
   if left(@wkformat,2)='yy'
      begin
	    set @year = '20'+left(@week,2)+'-01-01' 
		set @week_l = right(@week,2)
	  end
	  else
	  if  right(@wkformat,2)='yy'
	    begin
	      set @year = '20'+right(@week,2)+'-01-01' 
		  set @week_l = left(@week,2)
	    end

	 set @week_date= dateadd(week,@week_l,@year) 
   return  ( @week_date)  
  
END  

select dbo.get_WeekToDate('2417','mmyy') as lreturn

转载请注明出处，尊重他人劳动成果。欧少编写于2017-09-21