按日期获取月的第几周--学习的忘了出处
SELECT
[Time],
CONVERT(varchar, YEAR([Time])) +'年'+CONVERT(varchar, month([Time])) +'月第'+CONVERT(varchar,
datepart(d,[Time])/7 + (case when datepart(d,[Time])%7>datepart(weekday,[Time])
then 2
when (datepart(d,[Time])%7 = 0 and datep...
原创
2020-12-10 14:57:25 ·
84 阅读 ·
0 评论