Question

mysql中怎样用select语句显示今天的日期和两个月前的日期？

Answer 1

SELECT NOW(),DATE_ADD(NOW(), INTERVAL -2 MONTH),CURDATE(),DATE_ADD(CURDATE(), INTERVAL -2 MONTH)

now() DATE_ADD(NOW(), INTERVAL -2 MONTH) curdate() date_add(CURDATE(), interval -2 month)
2012-05-04 10:42:23 2012-03-04 10:42:23 2012-05-04 2012-03-04