MySql获取七天前，今天，本周第一天，上周一到上周日，格式化时间SQL样例

SELECT DATE_SUB(CURDATE(), INTERVAL 7 DAY) 七天前,
DATE_FORMAT(NOW(), ‘%Y%m%d’) 今天,
DATE_SUB(CURDATE(), INTERVAL 0 DAY) 今天,
DATE_FORMAT(date_sub(NOW(),interval 1 day), ‘%H’) ,
DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL 0 DAY), ‘%y%m%d’) 格式化今天,
date_sub(NOW(),interval 7 day) 七天前当前时间,
date_sub(curdate(),INTERVAL WEEKDAY(curdate()) + 0 DAY) 本周第一天,
date_sub(curdate(),INTERVAL WEEKDAY(curdate()) + 1 DAY) 本周日,
date_sub(curdate(),INTERVAL WEEKDAY(curdate()) + 2 DAY) 上周六,
date_sub(curdate(),INTERVAL WEEKDAY(curdate()) + 3 DAY) 上周五,
date_sub(curdate(),INTERVAL WEEKDAY(curdate()) + 4 DAY) 上周四,
date_sub(curdate(),INTERVAL WEEKDAY(curdate()) + 5 DAY) 上周三,
date_sub(curdate(),INTERVAL WEEKDAY(curdate()) + 6 DAY) 上周二,
date_sub(curdate(),INTERVAL WEEKDAY(curdate()) + 7 DAY) 上周一,
date_sub(curdate(),INTERVAL WEEKDAY(curdate()) + 8 DAY) 上周日,
DATE_SUB(CURDATE(),INTERVAL 1 WEEK),
date_sub(curdate(),INTERVAL WEEKDAY(curdate()) + 2 DAY) ,
DATE_FORMAT(date_sub(curdate(),INTERVAL WEEKDAY(curdate()) + 2 DAY), ‘%d’)
;