update record set fee=fee*0.5 where datediff(mm,begintime,getdate())=1 and datename(dw,begintime)='星期六' or datename(dw,begintime)='星期日'
Sql计算上个月星期六、天,上网费用打折.txt
最新推荐文章于 2024-08-09 09:47:03 发布
update record set fee=fee*0.5 where datediff(mm,begintime,getdate())=1 and datename(dw,begintime)='星期六' or datename(dw,begintime)='星期日'