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

SQL中，将周期转换为日期，取当周第一天的日期，格式：dbo.get_WeekToDate(Week,WeekFormat)CREATE Function [dbo].[get_WeekToDate](@week varchar(4),@wkformat varchar(4))     Returns  dateAS  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