SELECT NOW(),CURDATE(),CURTIME(),DATE_SUB(CURDATE(), INTERVAL 7 DAY),DATE_SUB(CURDATE(), INTERVAL 1 MONTH) 返回: 日期函数 NOW() CURDATE() CURTIME() DATE_SUB(CURDATE(), INTERVAL 7 DAY) DATE_SUB(CURDATE(), INTERVAL 1 MONTH) 2016-03-01 14:41:31 2016-03-01 14:41:31 2016-02-23 2016-02-01