How to add some amount of time from now?(MySQL)

Question

How can I add certain amount of time from now in mysql?

INSERT INTO rank(id, username, rank_type, time_start, time_end, activated) 
VALUES (NULL, 'somename', 1, NOW(), DATE(NOW() + INTERVAL 30 DAY), 0);

It says syntax error. I think the problem is caused by DATE function. Also tried to use NOW() + INTERVAL 30 DAY, but it didn't work either.

possible duplicate of [Mysql datetime format add 10 minutes](http://stackoverflow.com/questions/18188056/mysql-datetime-format-add-10-minutes) — Sylvain Leroux, Aug 14 '13 at 21:21

Joel · Accepted Answer · 2013-08-14T21:29:04.437

1

I think DATE_ADD(date,INTERVAL expr type) is what you are looking for..

INSERT INTO rank(id, username, rank_type, time_start, time_end, activated) 
VALUES (NULL, 'somename', 1, NOW(), DATE_ADD(NOW(), INTERVAL 30 DAY),0);

Some documentation can be found here

Here is an SQLFiddle

edited Aug 14 '13 at 21:29

answered Aug 14 '13 at 21:14

Joel

score 0 · Answer 2 · answered Aug 14 '13 at 21:21

The problem isn't in the date math. Just leave off the second parameter to DATE(), as in:

INSERT INTO rank(id, username, rank_type, time_start, time_end, activated) 
VALUES (NULL, 'somename', 1, NOW(), DATE(NOW() + INTERVAL 30 DAY));

2 Answers2