MySQL DATE_ADD INTERVAL

Question

    mysql_query("UPDATE tablename SET date = DATE_ADD(DATE(NOW() + INTERVAL 1 WEEK), INTERVAL 17 HOUR), INTERVAL 30 MINUTE)
        WHERE idevent = '2'")
or die(mysql_error());

I want to add 7 days to the date, but have the time aspect of datetime manually set. I have the code above, which works for the hour, but as soon as I add minutes it errors saying SQL syntax error.

Any ideas?

score 4 · Answer 1 · answered Feb 25 '12 at 22:52

You need another DATE_ADD() at the front of that expression, since you're doing two additions.

mysql_query("UPDATE tablename SET date = DATE_ADD(DATE_ADD(DATE(NOW() + INTERVAL 1 WEEK), INTERVAL 17 HOUR), INTERVAL 30 MINUTE) WHERE idevent = '2'");
//-------------------------------------^^^^^^^^^^^^^^^^^^^^

score 0 · Answer 2 · answered Feb 25 '12 at 22:54

0

What keeps you from adding 17*60+30 Minutes and keeping the code readable?

answered Feb 25 '12 at 22:54

Eugen Rieck

64,175
10
70
92

score -1 · Answer 3 · answered Feb 25 '12 at 22:53

-1

4 open '(' and 5 closing ')'. Disbalans.

answered Feb 25 '12 at 22:53

Odobenus Rosmarus

5,870
2
18
21

Its not an answer. It *should* be a comment. – Shiplu Mokaddim Feb 25 '12 at 22:58
2

it is answer that explains why author gets syntax error, which prevents him to add minutes. – Odobenus Rosmarus Feb 25 '12 at 23:20

MySQL DATE_ADD INTERVAL

3 Answers3