if datepart(day,getdate()) in (6,16,26) or (@@DATEFIRST+DATEPART(Weekday,getdate())-1)%7 in (0,6)
begin
print '会员日'
end
else
begin
print '非会员日'
end
将每月6,16,26和周末作为会员日。
[MSSQL]sql日期和周末判断
最新推荐文章于 2024-04-20 16:55:35 发布
if datepart(day,getdate()) in (6,16,26) or (@@DATEFIRST+DATEPART(Weekday,getdate())-1)%7 in (0,6)
begin
print '会员日'
end
else
begin
print '非会员日'
end
将每月6,16,26和周末作为会员日。