mysql - Mysql 上周 5 个工作日

Question

使用此查询:

date(timestamp_column) >= SUBDATE(curdate(), WEEKDAY(curdate())) -
interval 1 week AND date(timestamp_column) < SUBDATE(curdate(), WEEKDAY(curdate()))

我得到了上周的 7 天。我正在寻找的是 Mysql 中上周的 5 个工作日(周一至周五)。如果有人能提供帮助，我将不胜感激。谢谢

编辑感谢:

date(timestamp_column) > DATE_FORMAT(DATE_SUB(DATE_SUB(current_date, INTERVAL DAYOFWEEK(CURRENT_DATE)+5 day), INTERVAL 1 day), '%Y%m%d') 

and

date(timestamp_column) < DATE_FORMAT(DATE_SUB(current_date, INTERVAL DAYOFWEEK(CURRENT_DATE)-1 day), '%Y%m%d')does the trick, if anyone wants the code. 

Answer 1

在 2 和 6 之间添加 AND DAYOFWEEK(timestamp_column) 应该会有所帮助。

DAYOFWEEK(date)

Returns the weekday index for date (1 = Sunday, 2 = Monday, …, 7 = Saturday). These index values correspond to the ODBC standard.

来源:https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html#function_dayofweek