title: MySQL DATE_ADD INTERVAL
body: <pre><code>    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());
  </code></pre>
  
  <p>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.</p>
  
  <p>Any ideas?</p>