MySQL 获取今日、昨日、本周、上周、本月、上月、本年、去年日期
SELECT YEAR(CURDATE());
SELECT ( YEAR(CURDATE()) - 1 );
SELECT CONCAT( YEAR (CURDATE()), '-', MONTH (CURDATE()) );
SELECT CONCAT( YEAR (CURDATE()), '-', (MONTH(CURDATE()) - 1) );
SELECT DATE_SUB( CURDATE(), INTERVAL WEEKDAY(CURDATE()) DAY );
SELECT DATE_SUB( CURDATE(), INTERVAL WEEKDAY(CURDATE()) - 6 DAY );
SELECT DATE_SUB( CURDATE(), INTERVAL WEEKDAY(CURDATE()) + 7 DAY );
SELECT DATE_SUB( CURDATE(), INTERVAL WEEKDAY(CURDATE()) + 1 DAY );
SELECT CURDATE();
SELECT DATE_SUB( CURDATE(), INTERVAL WEEKDAY(CURDATE()) - 2 DAY );