How do you add 7 days to now()?

[twilightnights]

Can't find a tut on it can anyone help me?

How do you add 7 days to the now() function stored in database as 00-00-00 00:00:00

[btherl]

If you're dealing with datetimes, you can use these:

 

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-add

[Lumio]

<?php
$timestamp = time(); //the same as now()
$timestamp += 7*24*60*60; //adding 7 days in seconds
echo date('r', $timestamp);
?>

[twilightnights]

If you're dealing with datetimes, you can use these:

 

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-add

 

Ok I tried that but I can't get this to work..

 

$query7 = "UPDATE `tool` SET DueDate='DATE_ADD(now(),INTERVAL 7 DAYS)' WHERE ToolID='$Tool1'";

 

am I butchering the syntax?

[twilightnights]

also tried add_weeks

[Nhoj]

Not very good with date / time (I prefer UNIX_TIMESTAMP()'s) but it seems to me you're using

,INTERVAL 7 DAYS)

 

When you should be using

,INTERVAL 7 DAY)

[Lumio]

I do it like that:

<?php
$timestamp = time(); //the same as now()
$timestamp += 7*24*60*60; //adding 7 days in seconds
$sql = "UPDATE `table` SET `column` = ".$timestamp.";";
$result = mysql_query($sql);
?>

[Wildbug]

mysql> SELECT NOW(),NOW() + INTERVAL 7 DAY;
+---------------------+------------------------+
| NOW()               | NOW() + INTERVAL 7 DAY |
+---------------------+------------------------+
| 2007-06-14 15:37:39 | 2007-06-21 15:37:39    |
+---------------------+------------------------+
1 row in set (0.00 sec)