本年第一天:
DATE_SUB(CURDATE(),INTERVAL dayofyear(now())-1 DAY)
上月第一天:
DATE_SUB(DATE_SUB(CURDATE(),INTERVAL EXTRACT(DAY FROM CURDATE()) - 1 DAY),INTERVAL 1 MONTH)
上月最后一天:
DATE_SUB(DATE_SUB(CURDATE(),interval EXTRACT(DAY FROM CURDATE()) DAY),INTERVAL 0 MONTH)
本月第一天:
DATE_ADD(CURDATE(), INTERVAL - DAY(CURDATE()) + 1 DAY)
当前日期:
CURDATE()
本月最后一天:
DATE_SUB(date_sub(CURDATE(),INTERVAL EXTRACT(DAY FROM CURDATE()) DAY),INTERVAL -1 MONTH)
最近30天:
BETWEEN DATE_SUB(CURDATE(), INTERVAL 30 DAY) AND CURDATE()
未完待续 …