日期時間加減

SELECT DATE_ADD('2000-12-31 23:59:59', INTERVAL 1 SECOND);+----------------------------------------------------+| DATE_ADD('2000-12-31 23:59:59', INTERVAL 1 SECOND) |+----------------------------------------------------+| 2001-01-01 00:00:00 |+----------------------------------------------------+

SELECT DATE_ADD('2010-12-31', INTERVAL 1 DAY);+-------------------------------------------------+| DATE_ADD('2010-12-31', INTERVAL 1 DAY) |+-------------------------------------------------+| 2011-01-01 |+-------------------------------------------------+