set @wk=12;set @dt=date_add(subdate(date('2009-01-01'),weekday('2009-01-01')), interval @wk-1 week);select @dt union all select date_add(@dt,interval 1 day) union all select date_add(@dt,interval 2 day) union all select date_add(@dt,interval 3 day) union all select date_add(@dt,interval 4 day) union all select date_add(@dt,interval 5 day) union all select date_add(@dt,interval 6 day)/** @dt ---------- 2009-03-16 2009-03-17 2009-03-18 2009-03-19 2009-03-20 2009-03-21 2009-03-22 **/set @wk=null; set @dt=null;
select date_add(@dt,interval 1 day) union all
select date_add(@dt,interval 2 day) union all
select date_add(@dt,interval 3 day) union all
select date_add(@dt,interval 4 day) union all
select date_add(@dt,interval 5 day) union all
select date_add(@dt,interval 6 day)/**
@dt
----------
2009-03-16
2009-03-17
2009-03-18
2009-03-19
2009-03-20
2009-03-21
2009-03-22
**/set @wk=null;
set @dt=null;
或者date_sub 获取周日期interval week就可以了