- BEGIN
- declare aWeek varchar(10);
- set @d=date_format(date_sub(current_date,interval 1 day),'%Y-%m-%d');
- set @begindate=date_sub(current_date(),interval WEEKDAY(current_date()) day);
- set @mtmp=date_format(@d,'%Y-%m');
- set @dtmp=CONCAT(@mtmp,'-01');
- set @wend=WEEK(date_add(@d,interval 6 day),2);
- set @wbeg=WEEK(date_add(@dtmp,interval 6 day),2);
- set @t=@wend-@wbeg+1;
- set aWeek=CONCAT(@mtmp,'-',@t);
- select aWeek;
- END
- --该片段来自于http://www.codesnippet.cn/detail/1706201614742.html
来源: http://www.codesnippet.cn/detail/1706201614742.html