8.06 计算一年中周内各日期的次数

select date_format(
date_add(
cast(
concat(year(current_date),‘-01-01‘)
as date),
interval t500.id-1 day),
‘%W%) day,
count(*)
from t500
where t500.id<=datediff(
cast(
concat(year(current_date)+1,‘-01-01‘)
as date),
cast(
concat(year(current_date),‘-01-01‘)
as date))
group by date_format(
date_add(
cast(
concat(year(current_date),‘-01-01‘)
as date),
interval t500.id-1 day),
‘%W%)

8.06 计算一年中周内各日期的次数

原文：http://www.cnblogs.com/liang545621/p/7523311.html