create function ChangeDate
(
@DATE DATETIME
)
RETURNS INT
AS
begin
DECLARE @day int;
DECLARE @days int; --1表示上旬,2表示中旬,3表示下旬
set @days=day(@DATE);
set @day=case when @days<=10 then 1
when @days>20 then 3
else 2
end
return @day;
end
(
@DATE DATETIME
)
RETURNS INT
AS
begin
DECLARE @day int;
DECLARE @days int; --1表示上旬,2表示中旬,3表示下旬
set @days=day(@DATE);
set @day=case when @days<=10 then 1
when @days>20 then 3
else 2
end
return @day;
end