从周一到周日的mysql周 [英] mysql week from Monday till Sunday

问题描述

我想按年/周对数据进行分组，但周从星期日开始. 我如何将周一至周的一周进行分组?

i want to group my data by yearweek but the week starts here in sunday. how can i group my week from monday till sunday?

这是我的查询:

SELECT YEARWEEK(dateStats) k,dateStats udate, COUNT(f_shop) sales
FROM sal_import WHERE dateStats BETWEEN "2011-08-15" AND "2011-08-21" GROUP BY YEARWEEK(dateStats)

之间的日期是从星期一到星期日，我只需要一行即可.

The Between has a date from Monday till Sunday and i need just one row at the result.

非常感谢您

推荐答案

YEARWEEK(date[,mode])函数的第二个参数是mode-如

Second argument of YEARWEEK(date[,mode]) function is mode - like in WEEK(date[,mode]) function.

您可以指定开始日期-默认为0 (Sunday).

You can specify start day - default is 0 (Sunday).

只需将其设置为1 (Monday):

YEARWEEK(dateStats, 1)

这篇关于从周一到周日的mysql周的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！