mysql dayofweek函数包装

BEGIN
DECLARE result INT;
DECLARE temp INT;
SET temp=DAYOFWEEK(date);
select (case 
when temp=1 then 7
when temp=2 then 1
when temp=3 then 2
when temp=4 then 3
when temp=5 then 4
when temp=6 then 5
when temp=7 then 6
 else 0 end) INTO result;

RETURN result;
END