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