MySQL ADDDATE()

1 개요

MySQL ADDDATE(), DATE_ADD()

MySQL

Copy

SELECT ADDDATE('2008-01-02', 31);
# 2008-02-02

MySQL

Copy

SELECT ADDDATE('2008-01-02', INTERVAL 31 DAY);
# 2008-02-02

MySQL

Copy

SELECT DATE_ADD('2008-01-02', INTERVAL 31 DAY);
# 2008-02-02

2 같이 보기

• MySQL ADDTIME()
• MySQL 날짜 시간 함수

3 참고

• http://dev.mysql.com/doc/refman/5.6/en/date-and-time-functions.html#function_adddate