[MySQL] date_add 날짜 추가하기

MySQL 에서 날짜 계산

date_add( 기준날짜 , interval 추가하고자하는값 )

* 1day add
date_add( now, interval +1 day )     

* 1month add
date_add( now, interval +1 month ) 

* 1minute add
date_add(now(),interval +1 minute);

* 1 주전 날짜를 계산 할때는
date_add(now(),interval -1 week);

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2016-03-17 11:42:12 |
+---------------------+
1 row in set (0.00 sec)

mysql> select date_add(now(),interval +1 day);
+---------------------------------+
| date_add(now(),interval +1 day) |
+---------------------------------+
| 2016-03-18 11:43:06             |
+---------------------------------+
1 row in set (0.00 sec)