1、DATE_FORMAT(NOW(), '%Y-%m-%d 08:00:00')
2、DATE_SUB(NOW(), INTERVAL 1 DAY)
DATE_ADD(date,INTERVAL expr type)
DATE_SUB(date,INTERVAL expr type)
ADDDATE(date,INTERVAL expr type)
SUBDATE(date,INTERVAL expr type)
3、上个月初一: SUBDATE(SUBDATE(CURDATE(),INTERVAL DAY(CURDATE())-1 DAY), INTERVAL 1 MONTH)