mysql 之 上周周六到本周周五时间

SELECT
# 上周周六
DATE_FORMAT(SUBDATE(SUBDATE(CURDATE(),DATE_FORMAT(CURDATE(),'%w')),INTERVAL 1 DAY),'%Y%m%d') AS LAST_WK_BEGINE,
# 本周周五
DATE_FORMAT(SUBDATE(CURDATE(),DATE_FORMAT(CURDATE(),'%w')-5),'%Y%m%d') AS cm_wk_END
FROM DUAL