select time-interval WEEKDAY(time) day from x group by date_format(time,'%Y%u周')
%w mysql> select date_add(now(), interval -date_format(now(),'%w') day); +--------------------------------------------------------+ | date_add(now(), interval -date_format(now(),'%w') day) | +--------------------------------------------------------+ | 2017-02-26 09:58:53 | +--------------------------------------------------------+ 1 row in set (0.08 sec) mysql>
56,679
社区成员
56,709
社区内容
加载中
试试用AI创作助手写篇文章吧