update kaoqintest
set sixday = case
when datediff("dd", ddtt,'2004-1-1')%6=5
then '休息日'
else '工作日'
end
set sixday = case
when datediff("dd", ddtt,'2004-1-1')%6=5
then '休息日'
else '工作日'
end
set @dt ='2004-1-1'
update kaoqintest
set sixday = case
when datediff("dd", ddtt,@dt )%6=5
then '休息日'
else '工作日'
end
update kaoqintest
set sixday = case when datediff(dd, getdate(),'2004-1-1')%6=5 then '休息日'
else '工作日'
end
set sixday = case
when datediff("dd", ddtt,2004-1-1)%6=5 or datediff("dd", ddtt,2004-1-1)%6=-1
then '休息日'
else '工作日'
end