本文详细介绍了MySQL的YEARWEEK函数，包括其用法和不同模式的含义。YEARWEEK函数用于获取日期对应的年份和周数，通过设置参数可以调整一周的起始日。例如，SELECT YEARWEEK('2017-03-27',1)将从周一计算一周。在示例查询中，查询了atkg表中date_format(time, '%Y-%m-%d')过去一周的时间记录。
楼主应该的问的是YEARWEEK函数问题，YEARWEEK函数用法：
SELECT YEARWEEK('2017-03-27',1) //从周一开始计算一周
其中第二个参数是 mode ，具体指的意思如下：
MySQL 的 YEARWEEK 是获取年份和周数的一个函数，函数形式为 YEARWEEK(date[,mode])
Mode First day of week Range Week 1 is the first week …
0 Sunday 0-53 with a Sunday in this year
1 Monday 0-53 with more than 3 days this year
2 Sunday 1-53 with a Sunday in this year
3 Monday 1-53 with more than 3 days this year
4 Sunday 0-53 with more than 3 days this year
5 Monday 0-53 with a Monday in this year
6 Sunday 1-53 with more than 3 days this year
7 Monday 1-53 with a Monday in this year
按楼主你的写法：SELECT time FROM atkg WHERE YEARWEEK(date_format(time,'%Y-%m-%d'),1) = YEARWEEK(now(),1)-1
扫一扫
4458
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
